Overview

Dataset info

Number of variables183
Number of observations265
Missing cells21158 (43.6%)
Duplicate rows0 (0.0%)
Total size in memory365.6 KiB
Average record size in memory1.4 KiB

Variables types

Numeric63
Categorical23
Boolean25
Date0
URL0
Text (Unique)1
Rejected71
Unsupported0

Warnings

coligada_mais_antiga_ativa has 189 (71.3%) missing values Missing
coligada_mais_antiga_baixada has 264 (99.6%) missing values Missing
coligada_mais_nova_ativa has 189 (71.3%) missing values Missing
coligada_mais_nova_baixada has 264 (99.6%) missing values Missing
de_indicador_telefone has 71 (26.8%) missing values Missing
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
dt_situacao has a high cardinality: 129 distinct values Warning
empsetorcensitariofaixarendapopulacao has 48 (18.1%) missing values Missing
faturamento_est_coligados has 191 (72.1%) missing values Missing
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.9725637856) Rejected
fl_epp has constant value "False" Rejected
fl_matriz has constant value "True" Rejected
fl_me has constant value "False" Rejected
fl_mei has constant value "False" Rejected
fl_passivel_iss has constant value "True" Rejected
fl_st_especial has constant value "False" Rejected
grau_instrucao_macro_analfabeto has 201 (75.8%) missing values Missing
grau_instrucao_macro_desconhecido has constant value "nan" Rejected
grau_instrucao_macro_escolaridade_fundamental has 12 (4.5%) missing values Missing
grau_instrucao_macro_escolaridade_superior has 3 (1.1%) missing values Missing
idade_acima_de_58 has 8 (3.0%) missing values Missing
idade_ate_18 has 208 (78.5%) missing values Missing
idade_de_19_a_23 has 76 (28.7%) missing values Missing
idade_de_24_a_28 is highly correlated with idade_de_19_a_23 (ρ = 0.9391201682) Rejected
idade_de_39_a_43 is highly correlated with idade_de_34_a_38 (ρ = 0.9147291585) Rejected
idade_de_44_a_48 is highly correlated with idade_de_39_a_43 (ρ = 0.9376949593) Rejected
idade_de_54_a_58 is highly correlated with idade_acima_de_58 (ρ = 0.9500453674) Rejected
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 0.990757127) Rejected
idade_maxima_socios has 172 (64.9%) missing values Missing
idade_media_coligadas has 189 (71.3%) missing values Missing
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 0.9928275535) Rejected
idade_media_coligadas_baixadas has 264 (99.6%) missing values Missing
idade_media_socios has 172 (64.9%) missing values Missing
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 1) Rejected
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.9030093563) Rejected
max_faturamento_est_coligados is highly correlated with faturamento_est_coligados (ρ = 0.9484709664) Rejected
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.9515331439) Rejected
max_filiais_coligados has 229 (86.4%) missing values Missing
max_funcionarios_coligados_gp is highly correlated with max_filiais_coligados (ρ = 0.9312487825) Rejected
max_vl_folha_coligados has 207 (78.1%) missing values Missing
max_vl_folha_coligados_gp has 206 (77.7%) missing values Missing
media_faturamento_est_coligados is highly correlated with max_faturamento_est_coligados (ρ = 0.9075319591) Rejected
media_faturamento_est_coligados_gp is highly correlated with media_faturamento_est_coligados (ρ = 0.9465645673) Rejected
media_filiais_coligados has 229 (86.4%) missing values Missing
media_funcionarios_coligados_gp has 4 (1.5%) zeros Zeros
media_funcionarios_coligados_gp has 202 (76.2%) missing values Missing
media_vl_folha_coligados has 207 (78.1%) missing values Missing
media_vl_folha_coligados_gp has 206 (77.7%) missing values Missing
min_faturamento_est_coligados has 191 (72.1%) missing values Missing
min_faturamento_est_coligados_gp is highly correlated with min_faturamento_est_coligados (ρ = 0.9844779291) Rejected
min_filiais_coligados has 229 (86.4%) missing values Missing
min_funcionarios_coligados_gp is highly correlated with min_filiais_coligados (ρ = 0.916066893) Rejected
min_meses_servicos is highly correlated with meses_ultima_contratacaco (ρ = 0.9567491686) Rejected
min_meses_servicos_all has 19 (7.2%) zeros Zeros
min_vl_folha_coligados is highly correlated with min_funcionarios_coligados_gp (ρ = 0.9989755332) Rejected
min_vl_folha_coligados_gp is highly correlated with min_vl_folha_coligados (ρ = 0.9991732114) Rejected
nm_meso_regiao has 24 (9.1%) missing values Missing
nm_micro_regiao has a high cardinality: 57 distinct values Warning
nm_micro_regiao has 24 (9.1%) missing values Missing
qt_admitidos_12meses has 162 (61.1%) zeros Zeros
qt_alteracao_socio_180d has constant value "nan" Rejected
qt_alteracao_socio_365d has constant value "nan" Rejected
qt_alteracao_socio_90d has constant value "nan" Rejected
qt_alteracao_socio_total has constant value "nan" Rejected
qt_art has 135 (50.9%) missing values Missing
qt_coligadas has 189 (71.3%) missing values Missing
qt_coligados is highly correlated with qt_coligadas (ρ = 1) Rejected
qt_coligados_agropecuaria has 189 (71.3%) missing values Missing
qt_coligados_atividade_alto has 189 (71.3%) missing values Missing
qt_coligados_atividade_baixo has 189 (71.3%) missing values Missing
qt_coligados_atividade_inativo has 189 (71.3%) missing values Missing
qt_coligados_atividade_medio has 189 (71.3%) missing values Missing
qt_coligados_atividade_mt_baixo has 189 (71.3%) missing values Missing
qt_coligados_ativo is highly correlated with qt_coligados (ρ = 0.9997516702) Rejected
qt_coligados_baixada is highly correlated with max_funcionarios_coligados_gp (ρ = 0.9718460044) Rejected
qt_coligados_ccivil has 189 (71.3%) missing values Missing
qt_coligados_centro has 68 (25.7%) zeros Zeros
qt_coligados_centro has 189 (71.3%) missing values Missing
qt_coligados_comercio has 46 (17.4%) zeros Zeros
qt_coligados_comercio has 189 (71.3%) missing values Missing
qt_coligados_epp has 189 (71.3%) missing values Missing
qt_coligados_exterior has 189 (71.3%) missing values Missing
qt_coligados_inapta is highly correlated with max_funcionarios_coligados_gp (ρ = 0.9718460044) Rejected
qt_coligados_industria has 63 (23.8%) zeros Zeros
qt_coligados_industria has 189 (71.3%) missing values Missing
qt_coligados_ltda has 69 (26.0%) zeros Zeros
qt_coligados_ltda has 189 (71.3%) missing values Missing
qt_coligados_matriz is highly correlated with qt_coligados_ativo (ρ = 0.9996971343) Rejected
qt_coligados_me has 189 (71.3%) missing values Missing
qt_coligados_mei has 189 (71.3%) missing values Missing
qt_coligados_nordeste has 31 (11.7%) zeros Zeros
qt_coligados_nordeste has 189 (71.3%) missing values Missing
qt_coligados_norte has 39 (14.7%) zeros Zeros
qt_coligados_norte has 189 (71.3%) missing values Missing
qt_coligados_nula has 189 (71.3%) missing values Missing
qt_coligados_sa has 64 (24.2%) zeros Zeros
qt_coligados_sa has 189 (71.3%) missing values Missing
qt_coligados_serviço is highly correlated with qt_coligados_matriz (ρ = 0.9288399907) Rejected
qt_coligados_sudeste has 65 (24.5%) zeros Zeros
qt_coligados_sudeste has 189 (71.3%) missing values Missing
qt_coligados_sul is highly correlated with qt_coligados_baixada (ρ = 0.9612903226) Rejected
qt_coligados_suspensa has 189 (71.3%) missing values Missing
qt_desligados is highly correlated with qt_admitidos (ρ = 0.905610227) Rejected
qt_desligados_12meses has 159 (60.0%) zeros Zeros
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 0.9999991015) Rejected
qt_filiais has 155 (58.5%) zeros Zeros
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.9948729203) Rejected
qt_funcionarios_24meses is highly correlated with qt_funcionarios_12meses (ρ = 0.968894117) Rejected
qt_funcionarios_coligados has 5 (1.9%) zeros Zeros
qt_funcionarios_coligados has 202 (76.2%) missing values Missing
qt_funcionarios_coligados_gp is highly correlated with qt_coligados_inapta (ρ = 0.9231363224) Rejected
qt_funcionarios_grupo is highly correlated with qt_funcionarios_24meses (ρ = 0.9502971077) Rejected
qt_ramos_coligados is highly correlated with qt_coligados_matriz (ρ = 0.9346159264) Rejected
qt_regioes_coligados has 189 (71.3%) missing values Missing
qt_socios is highly correlated with qt_coligados_mei (ρ = 0.9899466719) Rejected
qt_socios_coligados has 189 (71.3%) missing values Missing
qt_socios_feminino is highly correlated with qt_socios (ρ = 0.9936468189) Rejected
qt_socios_masculino is highly correlated with qt_socios_feminino (ρ = 0.9916264524) Rejected
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 0.9954550751) Rejected
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 0.9960939342) Rejected
qt_socios_pj has 83 (31.3%) zeros Zeros
qt_socios_pj has 167 (63.0%) missing values Missing
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 1) Rejected
qt_socios_pj_baixados has 250 (94.3%) missing values Missing
qt_socios_pj_inaptos has 250 (94.3%) missing values Missing
qt_socios_pj_nulos has 250 (94.3%) missing values Missing
qt_socios_pj_suspensos has 250 (94.3%) missing values Missing
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.9983592345) Rejected
qt_socios_st_suspensa has constant value "nan" Rejected
qt_ufs_coligados is highly correlated with qt_regioes_coligados (ρ = 0.9026409791) Rejected
setor has constant value "SERVIÇO" Rejected
sg_uf_matriz is a recoding of sg_ufRejected
sum_faturamento_estimado_coligadas is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.9016602831) Rejected
total is highly correlated with qt_funcionarios_grupo (ρ = 0.9743124436) Rejected
total_filiais_coligados is highly correlated with qt_funcionarios_coligados_gp (ρ = 0.9354643228) Rejected
tx_crescimento_12meses has 161 (60.8%) zeros Zeros
tx_crescimento_24meses is highly correlated with tx_crescimento_12meses (ρ = 0.9959598268) Rejected
tx_rotatividade has 160 (60.4%) zeros Zeros
Unnamed_0_y is highly correlated with Unnamed_0_x (ρ = 0.9988970638) Rejected
vl_faturamento_estimado_grupo_aux is highly correlated with vl_faturamento_estimado_aux (ρ = 0.9811022766) Rejected
vl_folha_coligados is highly correlated with qt_funcionarios_coligados (ρ = 0.961120251) Rejected
vl_folha_coligados_gp is highly correlated with vl_folha_coligados (ρ = 0.9428868609) Rejected
vl_frota is highly correlated with qt_socios_pep (ρ = 0.9138805515) Rejected
vl_idade_maxima_socios_pj has 250 (94.3%) missing values Missing
vl_idade_media_socios_pj has 250 (94.3%) missing values Missing
vl_idade_minima_socios_pj has 250 (94.3%) missing values Missing
vl_potenc_cons_oleo_gas has 243 (91.7%) missing values Missing
vl_total_tancagem has 255 (96.2%) missing values Missing
vl_total_tancagem_grupo is highly correlated with vl_idade_minima_socios_pj (ρ = 0.9444166274) Rejected
vl_total_veiculos_antt has constant value "nan" Rejected
vl_total_veiculos_antt_grupo has constant value "nan" Rejected
vl_total_veiculos_leves is highly correlated with qt_socios_pep (ρ = 0.9328182339) Rejected
vl_total_veiculos_leves_grupo is highly correlated with vl_total_veiculos_leves (ρ = 0.9972729314) Rejected
vl_total_veiculos_pesados is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.9929030146) Rejected
vl_total_veiculos_pesados_grupo is highly correlated with vl_total_veiculos_pesados (ρ = 0.9978083954) Rejected

Variables

coligada_mais_antiga_ativa
Numeric

Distinct count77
Unique (%)29.1%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean289.7526316
Minimum2.3
Maximum642.6666667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.3
5-th percentile24.475
Q1116.3083333
Median272.7833333
Q3414.3416667
95-th percentile634.2166667
Maximum642.6666667
Range640.3666667
Interquartile range298.0333333

Descriptive statistics

Standard deviation193.4929426
Coef of variation0.667786662
Kurtosis-1.021551163
Mean289.7526316
MAD162.5111727
Skewness0.318938033
Sum22021.2
Variance37439.51885
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
408.4666667 1 0.4%
 
25.56666667 1 0.4%
 
42.36666667 1 0.4%
 
273.1666667 1 0.4%
 
194.2333333 1 0.4%
 
74.76666667 1 0.4%
 
5.8 1 0.4%
 
404.8 1 0.4%
 
178.3666667 1 0.4%
 
108.4666667 1 0.4%
 
Other values (66) 66 24.9%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
2.3 1 0.4%
 
5.8 1 0.4%
 
19.1 1 0.4%
 
21.2 1 0.4%
 
25.56666667 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
642.6666667 1 0.4%
 
635.4666667 1 0.4%
 
635.2333333 1 0.4%
 
634.2666667 1 0.4%
 
634.2 1 0.4%
 

coligada_mais_antiga_baixada
Categorical

Distinct count2
Unique (%)0.8%
Missing (%)99.6%
Missing (n)264
190.9
 
1
(Missing)
264
ValueCountFrequency (%) 
190.9 1 0.4%
 
(Missing) 264 99.6%
 
Max length5
Mean length3.00754717
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

coligada_mais_nova_ativa
Numeric

Distinct count74
Unique (%)27.9%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean92.76929825
Minimum2.033333333
Maximum498.9666667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.033333333
5-th percentile3.65
Q116.65833333
Median39.41666667
Q3122.0416667
95-th percentile334.4
Maximum498.9666667
Range496.9333333
Interquartile range105.3833333

Descriptive statistics

Standard deviation110.7867162
Coef of variation1.194217466
Kurtosis2.452633587
Mean92.76929825
MAD84.73578024
Skewness1.677094953
Sum7050.466667
Variance12273.6965
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
21.2 2 0.8%
 
19.1 2 0.8%
 
96.96666667 2 0.8%
 
109.8333333 1 0.4%
 
8.033333333 1 0.4%
 
83.83333333 1 0.4%
 
95.96666667 1 0.4%
 
377.9 1 0.4%
 
116.1333333 1 0.4%
 
222 1 0.4%
 
Other values (63) 63 23.8%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
2.033333333 1 0.4%
 
2.3 1 0.4%
 
2.4 1 0.4%
 
3.2 1 0.4%
 
3.8 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
498.9666667 1 0.4%
 
408.4666667 1 0.4%
 
377.9 1 0.4%
 
355.8 1 0.4%
 
327.2666667 1 0.4%
 

coligada_mais_nova_baixada
Categorical

Distinct count2
Unique (%)0.8%
Missing (%)99.6%
Missing (n)264
190.9
 
1
(Missing)
264
ValueCountFrequency (%) 
190.9 1 0.4%
 
(Missing) 264 99.6%
 
Max length5
Mean length3.00754717
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

de_faixa_faturamento_estimado
Categorical

Distinct count6
Unique (%)2.3%
Missing (%)0.0%
Missing (n)0
DE R$ 30.000.000,01 A R$ 100.000.000,00
138
DE R$ 10.000.000,01 A R$ 30.000.000,00
61
DE R$ 100.000.000,01 A R$ 300.000.000,00
49
Other values (3)
 
17
ValueCountFrequency (%) 
DE R$ 30.000.000,01 A R$ 100.000.000,00 138 52.1%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 61 23.0%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 49 18.5%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 9 3.4%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 6 2.3%
 
ACIMA DE 1 BILHAO DE REAIS 2 0.8%
 
Max length40
Mean length38.91320755
Min length26
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count6
Unique (%)2.3%
Missing (%)0.0%
Missing (n)0
DE R$ 30.000.000,01 A R$ 100.000.000,00
135
DE R$ 10.000.000,01 A R$ 30.000.000,00
59
DE R$ 100.000.000,01 A R$ 300.000.000,00
54
Other values (3)
 
17
ValueCountFrequency (%) 
DE R$ 30.000.000,01 A R$ 100.000.000,00 135 50.9%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 59 22.3%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 54 20.4%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 7 2.6%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 7 2.6%
 
ACIMA DE 1 BILHAO DE REAIS 3 1.1%
 
Max length40
Mean length38.88679245
Min length26
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_indicador_telefone
Categorical

Distinct count2
Unique (%)0.8%
Missing (%)26.8%
Missing (n)71
BOA
194
(Missing)
71
ValueCountFrequency (%) 
BOA 194 73.2%
 
(Missing) 71 26.8%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

de_natureza_juridica
Categorical

Distinct count25
Unique (%)9.4%
Missing (%)0.0%
Missing (n)0
MUNICIPIO
108
SOCIEDADE EMPRESARIA LIMITADA
62
ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL
 
20
Other values (22)
75
ValueCountFrequency (%) 
MUNICIPIO 108 40.8%
 
SOCIEDADE EMPRESARIA LIMITADA 62 23.4%
 
ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL 20 7.5%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 13 4.9%
 
ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL 9 3.4%
 
ASSOCIACAO PRIVADA 8 3.0%
 
AUTARQUIA ESTADUAL OU DO DISTRITO FEDERAL 6 2.3%
 
SERVICO SOCIAL AUTONOMO 5 1.9%
 
COOPERATIVA 4 1.5%
 
AUTARQUIA FEDERAL 4 1.5%
 
Other values (15) 26 9.8%
 
Max length70
Mean length25.58490566
Min length9
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count3
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
ALTA
236
MEDIA
 
26
BAIXA
 
3
ValueCountFrequency (%) 
ALTA 236 89.1%
 
MEDIA 26 9.8%
 
BAIXA 3 1.1%
 
Max length5
Mean length4.109433962
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

de_ramo
Categorical

Distinct count16
Unique (%)6.0%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL
150
SERVICOS ADMINISTRATIVOS
35
SERVICOS DE EDUCACAO
 
22
Other values (13)
58
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL 150 56.6%
 
SERVICOS ADMINISTRATIVOS 35 13.2%
 
SERVICOS DE EDUCACAO 22 8.3%
 
TRANSPORTE, ARMAZENAGEM E CORREIO 14 5.3%
 
SERVICOS DE SAUDE 13 4.9%
 
SERVICOS DE SANEAMENTO BASICO 5 1.9%
 
SERVICOS DE ALOJAMENTO/ALIMENTACAO 5 1.9%
 
SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS 5 1.9%
 
SERVICOS DIVERSOS 4 1.5%
 
TELECOM 3 1.1%
 
Other values (6) 9 3.4%
 
Max length49
Mean length38.54716981
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Categorical

Distinct count3
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
ACIMA DE 1 ANO
263
SEM INFORMACAO
 
1
ATE 1 ANO
 
1
ValueCountFrequency (%) 
ACIMA DE 1 ANO 263 99.2%
 
SEM INFORMACAO 1 0.4%
 
ATE 1 ANO 1 0.4%
 
Max length14
Mean length13.98113208
Min length9
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_saude_tributaria
Categorical

Distinct count5
Unique (%)1.9%
Missing (%)0.0%
Missing (n)0
VERDE
159
AZUL
83
LARANJA
 
20
Other values (2)
 
3
ValueCountFrequency (%) 
VERDE 159 60.0%
 
AZUL 83 31.3%
 
LARANJA 20 7.5%
 
VERMELHO 2 0.8%
 
CINZA 1 0.4%
 
Max length8
Mean length4.860377358
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count129
Unique (%)48.7%
Missing (%)0.0%
Missing (n)0
2005-11-03
85
1998-07-28
 
13
2005-09-24
 
10
Other values (126)
157
ValueCountFrequency (%) 
2005-11-03 85 32.1%
 
1998-07-28 13 4.9%
 
2005-09-24 10 3.8%
 
2005-10-14 4 1.5%
 
1999-02-27 4 1.5%
 
2005-08-27 4 1.5%
 
2005-10-28 4 1.5%
 
2005-10-07 3 1.1%
 
2005-08-06 3 1.1%
 
2005-10-22 3 1.1%
 
Other values (119) 132 49.8%
 
Max length10
Mean length10
Min length10
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count208
Unique (%)78.5%
Missing (%)18.1%
Missing (n)48
Infinite (%)0.0%
Infinite (n)0
Mean1587.10682
Minimum297.41
Maximum6347.86
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum297.41
5-th percentile405.494
Q1708.95
Median1072.28
Q32179.92
95-th percentile4133.876
Maximum6347.86
Range6050.45
Interquartile range1470.97

Descriptive statistics

Standard deviation1235.757393
Coef of variation0.7786226969
Kurtosis2.385943631
Mean1587.10682
MAD949.6950676
Skewness1.588122545
Sum344402.18
Variance1527096.333
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1005.09 3 1.1%
 
1068.09 2 0.8%
 
2317.14 2 0.8%
 
1881.35 2 0.8%
 
2179.92 2 0.8%
 
1213.54 2 0.8%
 
1375.69 2 0.8%
 
2799.81 2 0.8%
 
1530.23 2 0.8%
 
960.76 1 0.4%
 
Other values (197) 197 74.3%
 
(Missing) 48 18.1%
 

Minimum 5 values

ValueCountFrequency (%) 
297.41 1 0.4%
 
339.08 1 0.4%
 
353.66 1 0.4%
 
365.15 1 0.4%
 
365.3 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
6347.86 1 0.4%
 
5985.49 1 0.4%
 
5985.39 1 0.4%
 
5463.12 1 0.4%
 
5261.19 1 0.4%
 

faturamento_est_coligados
Numeric

Distinct count62
Unique (%)23.4%
Missing (%)72.1%
Missing (n)191
Infinite (%)0.0%
Infinite (n)0
Mean289284759.7
Minimum123638.3984
Maximum7559949122
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum123638.3984
5-th percentile210000
Q1807279.6094
Median5192125.824
Q355464072.81
95-th percentile710049020.8
Maximum7559949122
Range7559825483
Interquartile range54656793.2

Descriptive statistics

Standard deviation1135823648
Coef of variation3.926316923
Kurtosis28.39111034
Mean289284759.7
MAD458450248.1
Skewness5.228047835
Sum2.140707222e+10
Variance1.290095359e+18
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 10 3.8%
 
420000 3 1.1%
 
930000 2 0.8%
 
494553.5938 2 0.8%
 
5223030950 1 0.4%
 
84164409.75 1 0.4%
 
3727151686 1 0.4%
 
11282004 1 0.4%
 
928938553.6 1 0.4%
 
3449140.75 1 0.4%
 
Other values (51) 51 19.2%
 
(Missing) 191 72.1%
 

Minimum 5 values

ValueCountFrequency (%) 
123638.3984 1 0.4%
 
210000 10 3.8%
 
247276.7969 1 0.4%
 
288489.5938 1 0.4%
 
420000 3 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7559949122 1 0.4%
 
5223030950 1 0.4%
 
3727151686 1 0.4%
 
928938553.6 1 0.4%
 
592185426.2 1 0.4%
 

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.9725637856

fl_antt
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
253
True
 
12
ValueCountFrequency (%) 
False 253 95.5%
 
True 12 4.5%
 

fl_email
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
147
True
118
ValueCountFrequency (%) 
False 147 55.5%
 
True 118 44.5%
 

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_ltda
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
264
True
 
1
ValueCountFrequency (%) 
False 264 99.6%
 
True 1 0.4%
 

fl_matriz
Constant

This variable is constant and should be ignored for analysis

Constant valueTrue

fl_me
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_mei
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_optante_simei
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.8%
Missing (n)2
False
263
(Missing)
 
2
ValueCountFrequency (%) 
False 263 99.2%
 
(Missing) 2 0.8%
 

fl_optante_simples
Boolean

Distinct count3
Unique (%)1.1%
Missing (%)0.8%
Missing (n)2
False
252
True
 
11
(Missing)
 
2
ValueCountFrequency (%) 
False 252 95.1%
 
True 11 4.2%
 
(Missing) 2 0.8%
 

fl_passivel_iss
Constant

This variable is constant and should be ignored for analysis

Constant valueTrue

fl_rm
Categorical

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
NAO
145
SIM
120
ValueCountFrequency (%) 
NAO 145 54.7%
 
SIM 120 45.3%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

fl_sa
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
260
True
 
5
ValueCountFrequency (%) 
False 260 98.1%
 
True 5 1.9%
 

fl_simples_irregular
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
264
True
 
1
ValueCountFrequency (%) 
False 264 99.6%
 
True 1 0.4%
 

fl_spa
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
255
True
 
10
ValueCountFrequency (%) 
False 255 96.2%
 
True 10 3.8%
 

fl_st_especial
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_telefone
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
133
True
132
ValueCountFrequency (%) 
False 133 50.2%
 
True 132 49.8%
 

fl_veiculo
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
True
221
False
 
44
ValueCountFrequency (%) 
True 221 83.4%
 
False 44 16.6%
 

grau_instrucao_macro_analfabeto
Numeric

Distinct count15
Unique (%)5.7%
Missing (%)75.8%
Missing (n)201
Infinite (%)0.0%
Infinite (n)0
Mean6.21875
Minimum1
Maximum66
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q34.25
95-th percentile24
Maximum66
Range65
Interquartile range3.25

Descriptive statistics

Standard deviation12.3564375
Coef of variation1.986964824
Kurtosis15.39379909
Mean6.21875
MAD6.692382812
Skewness3.805688551
Sum398
Variance152.6815476
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%) 
1 24 9.1%
 
2 13 4.9%
 
3 8 3.0%
 
24 3 1.1%
 
4 3 1.1%
 
9 2 0.8%
 
8 2 0.8%
 
6 2 0.8%
 
7 2 0.8%
 
64 1 0.4%
 
Other values (4) 4 1.5%
 
(Missing) 201 75.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1 24 9.1%
 
2 13 4.9%
 
3 8 3.0%
 
4 3 1.1%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
66 1 0.4%
 
64 1 0.4%
 
33 1 0.4%
 
24 3 1.1%
 
12 1 0.4%
 

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

grau_instrucao_macro_escolaridade_fundamental
Numeric

Distinct count130
Unique (%)49.1%
Missing (%)4.5%
Missing (n)12
Infinite (%)0.0%
Infinite (n)0
Mean76.55335968
Minimum1
Maximum668
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1.6
Q115
Median45
Q396
95-th percentile253
Maximum668
Range667
Interquartile range81

Descriptive statistics

Standard deviation105.8099999
Coef of variation1.38217317
Kurtosis11.1841695
Mean76.55335968
MAD66.39581934
Skewness3.086906223
Sum19368
Variance11195.75607
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 13 4.9%
 
18 7 2.6%
 
19 6 2.3%
 
4 6 2.3%
 
7 6 2.3%
 
9 5 1.9%
 
17 5 1.9%
 
15 5 1.9%
 
54 5 1.9%
 
12 5 1.9%
 
Other values (119) 190 71.7%
 
(Missing) 12 4.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 13 4.9%
 
2 4 1.5%
 
3 4 1.5%
 
4 6 2.3%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
668 1 0.4%
 
595 1 0.4%
 
576 1 0.4%
 
559 1 0.4%
 
499 1 0.4%
 

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count196
Unique (%)74.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean221.0264151
Minimum4
Maximum2447
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4
5-th percentile23
Q173
Median140
Q3255
95-th percentile638.6
Maximum2447
Range2443
Interquartile range182

Descriptive statistics

Standard deviation273.2013411
Coef of variation1.236057423
Kurtosis22.39937334
Mean221.0264151
MAD162.8438305
Skewness3.971661552
Sum58572
Variance74638.97278
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 4. 150.5 255.5 400.5 722.5 2447. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
134 4 1.5%
 
145 4 1.5%
 
49 4 1.5%
 
35 3 1.1%
 
122 3 1.1%
 
23 3 1.1%
 
117 3 1.1%
 
252 3 1.1%
 
40 3 1.1%
 
107 3 1.1%
 
Other values (186) 232 87.5%
 

Minimum 5 values

ValueCountFrequency (%) 
4 1 0.4%
 
5 1 0.4%
 
6 2 0.8%
 
9 1 0.4%
 
11 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2447 1 0.4%
 
1662 1 0.4%
 
1581 1 0.4%
 
1193 2 0.8%
 
1164 1 0.4%
 

grau_instrucao_macro_escolaridade_superior
Numeric

Distinct count179
Unique (%)67.5%
Missing (%)1.1%
Missing (n)3
Infinite (%)0.0%
Infinite (n)0
Mean174.0419847
Minimum1
Maximum2471
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile3
Q140.25
Median90
Q3192.75
95-th percentile567.75
Maximum2471
Range2470
Interquartile range152.5

Descriptive statistics

Standard deviation272.8321487
Coef of variation1.567622601
Kurtosis26.49629512
Mean174.0419847
MAD155.0061768
Skewness4.407661604
Sum45599
Variance74437.38137
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
3 7 2.6%
 
2 5 1.9%
 
56 4 1.5%
 
8 4 1.5%
 
7 4 1.5%
 
72 4 1.5%
 
63 4 1.5%
 
44 3 1.1%
 
13 3 1.1%
 
37 3 1.1%
 
Other values (168) 221 83.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 3 1.1%
 
2 5 1.9%
 
3 7 2.6%
 
4 2 0.8%
 
5 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
2471 1 0.4%
 
1820 1 0.4%
 
1349 1 0.4%
 
1292 1 0.4%
 
1168 1 0.4%
 

id
Categorical, Unique

First 5 values
001f6dfaefdbbe31deedb00996c8a87dd90342690611d6...
01a586fca9efeab9f83ccab019962b0887882fac2625fe...
03db1b36296ff895e6494a04d94795b247a78301dec8c0...
04732bec03125a8a17f1191cbd7c6dc675628bbb87125c...
04d34dcdee40a44560907165ab68f8e0ec771c0b94321f...
Last 5 values
fe796f2c60812f6fe96affa216079cf548daa25c3b72ea...
fea23f072675ec89f9b6ffd040777f5ff562c9d7623918...
feb9c97a3f694c22a919d9544c433da92d34d5717b43d5...
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3...
ff9ff2ac35ec7cf5c7d5ed561010a53a953108110a3f5c...

First 5 values

ValueCountFrequency (%) 
001f6dfaefdbbe31deedb00996c8a87dd90342690611d6a0be7fbb19e4b5326c 1 0.4%
 
01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2 1 0.4%
 
03db1b36296ff895e6494a04d94795b247a78301dec8c0559bed9924436cc058 1 0.4%
 
04732bec03125a8a17f1191cbd7c6dc675628bbb87125c4f717b81d9c3bedd6e 1 0.4%
 
04d34dcdee40a44560907165ab68f8e0ec771c0b94321f688d7a202d73f52673 1 0.4%
 

Last 5 values

ValueCountFrequency (%) 
ff9ff2ac35ec7cf5c7d5ed561010a53a953108110a3f5cdcea92945d94b62d38 1 0.4%
 
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6 1 0.4%
 
feb9c97a3f694c22a919d9544c433da92d34d5717b43d54d88f543aa462958ae 1 0.4%
 
fea23f072675ec89f9b6ffd040777f5ff562c9d76239180a2e1786f917f3a52f 1 0.4%
 
fe796f2c60812f6fe96affa216079cf548daa25c3b72ea746d8ad2c25c131d1b 1 0.4%
 

idade_acima_de_58
Numeric

Distinct count105
Unique (%)39.6%
Missing (%)3.0%
Missing (n)8
Infinite (%)0.0%
Infinite (n)0
Mean53.91050584
Minimum1
Maximum1844
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2
Q110
Median27
Q357
95-th percentile182.2
Maximum1844
Range1843
Interquartile range47

Descriptive statistics

Standard deviation131.1446443
Coef of variation2.432636131
Kurtosis138.7295025
Mean53.91050584
MAD50.67910188
Skewness10.65083773
Sum13855
Variance17198.91774
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
2 9 3.4%
 
5 9 3.4%
 
17 8 3.0%
 
3 8 3.0%
 
6 8 3.0%
 
11 8 3.0%
 
12 8 3.0%
 
1 7 2.6%
 
4 6 2.3%
 
8 6 2.3%
 
Other values (94) 180 67.9%
 
(Missing) 8 3.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 7 2.6%
 
2 9 3.4%
 
3 8 3.0%
 
4 6 2.3%
 
5 9 3.4%
 

Maximum 5 values

ValueCountFrequency (%) 
1844 1 0.4%
 
727 1 0.4%
 
307 1 0.4%
 
254 1 0.4%
 
235 1 0.4%
 

idade_ate_18
Numeric

Distinct count13
Unique (%)4.9%
Missing (%)78.5%
Missing (n)208
Infinite (%)0.0%
Infinite (n)0
Mean4.403508772
Minimum1
Maximum56
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q35
95-th percentile10
Maximum56
Range55
Interquartile range4

Descriptive statistics

Standard deviation7.596661976
Coef of variation1.725138377
Kurtosis39.31533632
Mean4.403508772
MAD3.527854725
Skewness5.8714155
Sum251
Variance57.70927318
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%) 
1 16 6.0%
 
2 13 4.9%
 
3 10 3.8%
 
6 5 1.9%
 
7 3 1.1%
 
4 2 0.8%
 
10 2 0.8%
 
5 2 0.8%
 
8 1 0.4%
 
56 1 0.4%
 
Other values (2) 2 0.8%
 
(Missing) 208 78.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 16 6.0%
 
2 13 4.9%
 
3 10 3.8%
 
4 2 0.8%
 
5 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
56 1 0.4%
 
17 1 0.4%
 
10 2 0.8%
 
9 1 0.4%
 
8 1 0.4%
 

idade_de_19_a_23
Numeric

Distinct count43
Unique (%)16.2%
Missing (%)28.7%
Missing (n)76
Infinite (%)0.0%
Infinite (n)0
Mean15.14285714
Minimum1
Maximum643
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q13
Median6
Q316
95-th percentile37.8
Maximum643
Range642
Interquartile range13

Descriptive statistics

Standard deviation48.70171602
Coef of variation3.216151058
Kurtosis148.9475845
Mean15.14285714
MAD14.88737717
Skewness11.64694624
Sum2862
Variance2371.857143
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=43)
ValueCountFrequency (%) 
1 27 10.2%
 
2 19 7.2%
 
3 15 5.7%
 
4 13 4.9%
 
6 12 4.5%
 
5 12 4.5%
 
7 10 3.8%
 
10 8 3.0%
 
18 6 2.3%
 
19 5 1.9%
 
Other values (32) 62 23.4%
 
(Missing) 76 28.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 27 10.2%
 
2 19 7.2%
 
3 15 5.7%
 
4 13 4.9%
 
5 12 4.5%
 

Maximum 5 values

ValueCountFrequency (%) 
643 1 0.4%
 
139 1 0.4%
 
102 1 0.4%
 
65 1 0.4%
 
57 1 0.4%
 

idade_de_24_a_28
Highly correlated

This variable is highly correlated with idade_de_19_a_23 and should be ignored for analysis

Correlation0.9391201682

idade_de_29_a_33
Numeric

Distinct count117
Unique (%)44.2%
Missing (%)0.4%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean61.93560606
Minimum2
Maximum749
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q123.75
Median40
Q370.25
95-th percentile171.95
Maximum749
Range747
Interquartile range46.5

Descriptive statistics

Standard deviation81.47251993
Coef of variation1.315439133
Kurtosis29.98701438
Mean61.93560606
MAD44.9774449
Skewness4.724876315
Sum16351
Variance6637.771503
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
32 7 2.6%
 
31 7 2.6%
 
11 7 2.6%
 
40 6 2.3%
 
22 6 2.3%
 
10 6 2.3%
 
27 6 2.3%
 
29 5 1.9%
 
25 5 1.9%
 
45 5 1.9%
 
Other values (106) 204 77.0%
 

Minimum 5 values

ValueCountFrequency (%) 
2 2 0.8%
 
3 1 0.4%
 
4 1 0.4%
 
5 1 0.4%
 
6 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
749 1 0.4%
 
603 1 0.4%
 
517 1 0.4%
 
357 1 0.4%
 
325 1 0.4%
 

idade_de_34_a_38
Numeric

Distinct count123
Unique (%)46.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean77.0754717
Minimum1
Maximum682
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile12
Q128
Median45
Q3102
95-th percentile246
Maximum682
Range681
Interquartile range74

Descriptive statistics

Standard deviation85.41096043
Coef of variation1.1081471
Kurtosis14.19407178
Mean77.0754717
MAD55.99629761
Skewness3.180956646
Sum20425
Variance7295.032161
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1. 18.5 48.5 130. 189.5 371.5 682. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
28 8 3.0%
 
21 7 2.6%
 
27 6 2.3%
 
41 6 2.3%
 
33 6 2.3%
 
42 6 2.3%
 
34 6 2.3%
 
37 5 1.9%
 
22 5 1.9%
 
23 5 1.9%
 
Other values (113) 205 77.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.4%
 
3 2 0.8%
 
6 1 0.4%
 
9 2 0.8%
 
10 3 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
682 1 0.4%
 
535 1 0.4%
 
444 1 0.4%
 
375 1 0.4%
 
368 1 0.4%
 

idade_de_39_a_43
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation0.9147291585

idade_de_44_a_48
Highly correlated

This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis

Correlation0.9376949593

idade_de_49_a_53
Numeric

Distinct count116
Unique (%)43.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean53.50188679
Minimum1
Maximum532
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile5.2
Q119
Median37
Q364
95-th percentile163
Maximum532
Range531
Interquartile range45

Descriptive statistics

Standard deviation58.86696124
Coef of variation1.100278229
Kurtosis18.51098245
Mean53.50188679
MAD37.91572802
Skewness3.374100194
Sum14178
Variance3465.319125
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1. 60.5 123.5 257. 532. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
14 9 3.4%
 
21 6 2.3%
 
22 6 2.3%
 
31 6 2.3%
 
15 6 2.3%
 
30 6 2.3%
 
28 6 2.3%
 
7 6 2.3%
 
16 5 1.9%
 
8 5 1.9%
 
Other values (106) 204 77.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 2 0.8%
 
2 2 0.8%
 
3 2 0.8%
 
4 4 1.5%
 
5 4 1.5%
 

Maximum 5 values

ValueCountFrequency (%) 
532 1 0.4%
 
315 1 0.4%
 
266 1 0.4%
 
248 1 0.4%
 
235 1 0.4%
 

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_acima_de_58 and should be ignored for analysis

Correlation0.9500453674

idade_emp_cat
Categorical

Distinct count6
Unique (%)2.3%
Missing (%)0.0%
Missing (n)0
> 20
176
15 a 20
 
33
5 a 10
 
27
Other values (3)
 
29
ValueCountFrequency (%) 
> 20 176 66.4%
 
15 a 20 33 12.5%
 
5 a 10 27 10.2%
 
10 a 15 21 7.9%
 
1 a 5 7 2.6%
 
<= 1 1 0.4%
 
Max length7
Mean length4.841509434
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count214
Unique (%)80.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean27.76250194
Minimum0.7616438356
Maximum51.80821918
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.7616438356
5-th percentile6.068493151
Q117.63835616
Median24.0739726
Q343.8
95-th percentile47.15780822
Maximum51.80821918
Range51.04657534
Interquartile range26.16164384

Descriptive statistics

Standard deviation14.11960273
Coef of variation0.5085853846
Kurtosis-1.333726542
Mean27.76250194
MAD12.56690579
Skewness0.02010867161
Sum7357.063014
Variance199.3631811
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0.76164384 7.58767123 21.78630137 21.88356164 43.43835616 ... 43.85342466 43.85616438 43.87123288 43.94794521 51.80821918], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
43.85479452 11 4.2%
 
21.83561644 9 3.4%
 
21.83287671 6 2.3%
 
43.86575342 6 2.3%
 
43.87671233 5 1.9%
 
43.86849315 4 1.5%
 
43.84657534 4 1.5%
 
43.83287671 3 1.1%
 
21.81643836 3 1.1%
 
43.8 3 1.1%
 
Other values (204) 211 79.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0.7616438356 1 0.4%
 
1.002739726 1 0.4%
 
2.498630137 1 0.4%
 
2.6 1 0.4%
 
2.95890411 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
51.80821918 1 0.4%
 
51.49863014 1 0.4%
 
51.33424658 1 0.4%
 
50.92876712 1 0.4%
 
50.66027397 1 0.4%
 

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation0.990757127

idade_maxima_socios
Numeric

Distinct count50
Unique (%)18.9%
Missing (%)64.9%
Missing (n)172
Infinite (%)0.0%
Infinite (n)0
Mean54.96774194
Minimum4
Maximum90
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4
5-th percentile31.6
Q145
Median54
Q366
95-th percentile79.4
Maximum90
Range86
Interquartile range21

Descriptive statistics

Standard deviation15.46626878
Coef of variation0.2813699132
Kurtosis0.2465950917
Mean54.96774194
MAD12.35449185
Skewness-0.2249164359
Sum5112
Variance239.2054698
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
54 5 1.9%
 
50 4 1.5%
 
66 4 1.5%
 
49 4 1.5%
 
51 3 1.1%
 
33 3 1.1%
 
65 3 1.1%
 
47 3 1.1%
 
72 3 1.1%
 
55 3 1.1%
 
Other values (39) 58 21.9%
 
(Missing) 172 64.9%
 

Minimum 5 values

ValueCountFrequency (%) 
4 1 0.4%
 
27 1 0.4%
 
29 1 0.4%
 
30 1 0.4%
 
31 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
90 1 0.4%
 
86 1 0.4%
 
84 1 0.4%
 
82 1 0.4%
 
80 1 0.4%
 

idade_media_coligadas
Numeric

Distinct count77
Unique (%)29.1%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean174.0541455
Minimum2.3
Maximum498.9666667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.3
5-th percentile24.475
Q1102.8291667
Median156.6618056
Q3243.9458333
95-th percentile382.3583333
Maximum498.9666667
Range496.6666667
Interquartile range141.1166667

Descriptive statistics

Standard deviation108.4789161
Coef of variation0.6232481036
Kurtosis0.7833237045
Mean174.0541455
MAD85.83890719
Skewness0.8317969626
Sum13228.11506
Variance11767.67524
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
139.6222222 1 0.4%
 
358.9416667 1 0.4%
 
495.95 1 0.4%
 
16.8 1 0.4%
 
44.06666667 1 0.4%
 
276.6333333 1 0.4%
 
21.2 1 0.4%
 
102.8666667 1 0.4%
 
116.3666667 1 0.4%
 
243.8166667 1 0.4%
 
Other values (66) 66 24.9%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
2.3 1 0.4%
 
5.8 1 0.4%
 
16.8 1 0.4%
 
21.2 1 0.4%
 
25.56666667 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
498.9666667 1 0.4%
 
495.95 1 0.4%
 
408.4666667 1 0.4%
 
389.9833333 1 0.4%
 
379.8166667 1 0.4%
 

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation0.9928275535

idade_media_coligadas_baixadas
Categorical

Distinct count2
Unique (%)0.8%
Missing (%)99.6%
Missing (n)264
190.9
 
1
(Missing)
264
ValueCountFrequency (%) 
190.9 1 0.4%
 
(Missing) 264 99.6%
 
Max length5
Mean length3.00754717
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

idade_media_socios
Numeric

Distinct count63
Unique (%)23.8%
Missing (%)64.9%
Missing (n)172
Infinite (%)0.0%
Infinite (n)0
Mean49.94940271
Minimum4
Maximum90
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4
5-th percentile29.4
Q141
Median50
Q361
95-th percentile70.3
Maximum90
Range86
Interquartile range20

Descriptive statistics

Standard deviation13.80293694
Coef of variation0.2763383782
Kurtosis0.5110116608
Mean49.94940271
MAD11.17281318
Skewness-0.1185136621
Sum4645.294452
Variance190.5210681
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
64 3 1.1%
 
63 3 1.1%
 
55 3 1.1%
 
47 3 1.1%
 
33 3 1.1%
 
50 3 1.1%
 
52 3 1.1%
 
69 2 0.8%
 
46.66666667 2 0.8%
 
64.5 2 0.8%
 
Other values (52) 66 24.9%
 
(Missing) 172 64.9%
 

Minimum 5 values

ValueCountFrequency (%) 
4 1 0.4%
 
27 2 0.8%
 
28 1 0.4%
 
28.5 1 0.4%
 
30 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
90 1 0.4%
 
75.66666667 1 0.4%
 
72 1 0.4%
 
71 1 0.4%
 
70.75 1 0.4%
 

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation1

idade_minima_socios
Highly correlated

This variable is highly correlated with idade_media_socios and should be ignored for analysis

Correlation0.9030093563

max_faturamento_est_coligados
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.9484709664

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.9515331439

max_filiais_coligados
Numeric

Distinct count15
Unique (%)5.7%
Missing (%)86.4%
Missing (n)229
Infinite (%)0.0%
Infinite (n)0
Mean40.58333333
Minimum1
Maximum666
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11.75
Median4
Q37
95-th percentile178.25
Maximum666
Range665
Interquartile range5.25

Descriptive statistics

Standard deviation120.6691758
Coef of variation2.973367783
Kurtosis21.72829598
Mean40.58333333
MAD61.58333333
Skewness4.4449895
Sum1461
Variance14561.05
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%) 
1 9 3.4%
 
4 4 1.5%
 
3 4 1.5%
 
2 4 1.5%
 
7 3 1.1%
 
6 3 1.1%
 
5 2 0.8%
 
275 1 0.4%
 
666 1 0.4%
 
146 1 0.4%
 
Other values (4) 4 1.5%
 
(Missing) 229 86.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 9 3.4%
 
2 4 1.5%
 
3 4 1.5%
 
4 4 1.5%
 
5 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
666 1 0.4%
 
275 1 0.4%
 
146 1 0.4%
 
140 1 0.4%
 
76 1 0.4%
 

max_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_filiais_coligados and should be ignored for analysis

Correlation0.9312487825

max_meses_servicos
Numeric

Distinct count228
Unique (%)86.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean472.16
Minimum6
Maximum5099.066667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum6
5-th percentile46.49333333
Q1251.5
Median414.3333333
Q3521.3666667
95-th percentile641.3066667
Maximum5099.066667
Range5093.066667
Interquartile range269.8666667

Descriptive statistics

Standard deviation729.1793112
Coef of variation1.544347914
Kurtosis34.67675123
Mean472.16
MAD268.1125031
Skewness5.815251087
Sum125122.4
Variance531702.4679
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 6. 251.51666667 268.21666667 481.31666667 506.15 508.08333333 596.41666667 693.5 5099.06666667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
5099.066667 6 2.3%
 
507.2 5 1.9%
 
470.6666667 5 1.9%
 
265.6333333 5 1.9%
 
521.3666667 4 1.5%
 
265.6666667 4 1.5%
 
481.8333333 3 1.1%
 
495.0333333 3 1.1%
 
113.5333333 2 0.8%
 
123.6333333 2 0.8%
 
Other values (218) 226 85.3%
 

Minimum 5 values

ValueCountFrequency (%) 
6 1 0.4%
 
13.06666667 1 0.4%
 
26.23333333 1 0.4%
 
29.3 1 0.4%
 
30.33333333 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.066667 6 2.3%
 
804.4333333 1 0.4%
 
801.3666667 1 0.4%
 
707.3666667 1 0.4%
 
679.6333333 1 0.4%
 

max_meses_servicos_all
Numeric

Distinct count154
Unique (%)58.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2134.504151
Minimum13.06666667
Maximum5099.066667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum13.06666667
5-th percentile53.44666667
Q1257.3333333
Median490.4333333
Q35014.966667
95-th percentile5014.966667
Maximum5099.066667
Range5086
Interquartile range4757.633333

Descriptive statistics

Standard deviation2311.318392
Coef of variation1.082836213
Kurtosis-1.797733588
Mean2134.504151
MAD2245.220169
Skewness0.4491050719
Sum565643.6
Variance5342192.709
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 13.06666667 251.51666667 268.21666667 579.1 662.26666667 2847.3 5039.83333333 5099.06666667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
5014.966667 91 34.3%
 
5099.066667 6 2.3%
 
5064.7 5 1.9%
 
265.6666667 4 1.5%
 
265.6333333 4 1.5%
 
481.8333333 2 0.8%
 
373.2666667 2 0.8%
 
50.6 2 0.8%
 
387.4333333 2 0.8%
 
113.5333333 2 0.8%
 
Other values (144) 145 54.7%
 

Minimum 5 values

ValueCountFrequency (%) 
13.06666667 1 0.4%
 
26.23333333 1 0.4%
 
29.3 1 0.4%
 
29.36666667 1 0.4%
 
30.4 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.066667 6 2.3%
 
5065.733333 1 0.4%
 
5064.7 5 1.9%
 
5014.966667 91 34.3%
 
679.6333333 1 0.4%
 

max_vl_folha_coligados
Numeric

Distinct count56
Unique (%)21.1%
Missing (%)78.1%
Missing (n)207
Infinite (%)0.0%
Infinite (n)0
Mean28700451.66
Minimum0
Maximum207712510
Zeros (%)0.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile141153.84
Q1819104.4
Median7871644.75
Q331666885.5
95-th percentile165981456
Maximum207712510
Range207712510
Interquartile range30847781.1

Descriptive statistics

Standard deviation50411040.49
Coef of variation1.756454605
Kurtosis5.42770491
Mean28700451.66
MAD33899732.93
Skewness2.437294092
Sum1664626196
Variance2.541273004e+15
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
247276.8 3 1.1%
 
370915.2 2 0.8%
 
13002638 1 0.4%
 
123432340 1 0.4%
 
75130936 1 0.4%
 
8531050 1 0.4%
 
33959348 1 0.4%
 
43953452 1 0.4%
 
8242560 1 0.4%
 
4224312 1 0.4%
 
Other values (45) 45 17.0%
 
(Missing) 207 78.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.4%
 
61819.2 1 0.4%
 
123638.4 1 0.4%
 
144244.8 1 0.4%
 
185457.6 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
207712510 1 0.4%
 
203920930 1 0.4%
 
171568880 1 0.4%
 
164995440 1 0.4%
 
123432340 1 0.4%
 

max_vl_folha_coligados_gp
Numeric

Distinct count58
Unique (%)21.9%
Missing (%)77.7%
Missing (n)206
Infinite (%)0.0%
Infinite (n)0
Mean75770780.64
Minimum61819.2
Maximum1390128400
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819.2
5-th percentile181336.32
Q11112745.6
Median8242560
Q341161284
95-th percentile285464576
Maximum1390128400
Range1390066581
Interquartile range40048538.4

Descriptive statistics

Standard deviation228286559.6
Coef of variation3.012857433
Kurtosis22.00973326
Mean75770780.64
MAD105783786.2
Skewness4.554564643
Sum4470476058
Variance5.211475331e+16
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
247276.8 3 1.1%
 
6820718.5 1 0.4%
 
123432340 1 0.4%
 
8531050 1 0.4%
 
43953452 1 0.4%
 
8242560 1 0.4%
 
783043.2 1 0.4%
 
288489.6 1 0.4%
 
123617790 1 0.4%
 
44736496 1 0.4%
 
Other values (47) 47 17.7%
 
(Missing) 206 77.7%
 

Minimum 5 values

ValueCountFrequency (%) 
61819.2 1 0.4%
 
123638.4 1 0.4%
 
144244.8 1 0.4%
 
185457.6 1 0.4%
 
247276.8 3 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1390128400 1 0.4%
 
898068100 1 0.4%
 
678300860 1 0.4%
 
241816100 1 0.4%
 
177421100 1 0.4%
 

media_faturamento_est_coligados
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.9075319591

media_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation0.9465645673

media_filiais_coligados
Numeric

Distinct count20
Unique (%)7.5%
Missing (%)86.4%
Missing (n)229
Infinite (%)0.0%
Infinite (n)0
Mean8.003972262
Minimum1
Maximum63
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11.5
Median2.1
Q34.125
95-th percentile41.125
Maximum63
Range62
Interquartile range2.625

Descriptive statistics

Standard deviation14.36052137
Coef of variation1.794174305
Kurtosis7.114313903
Mean8.003972262
MAD9.268296501
Skewness2.722577445
Sum288.1430014
Variance206.2245741
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%) 
1 9 3.4%
 
2 8 3.0%
 
4 3 1.1%
 
2.2 1 0.4%
 
10 1 0.4%
 
25 1 0.4%
 
2.5 1 0.4%
 
63 1 0.4%
 
6 1 0.4%
 
1.666666667 1 0.4%
 
Other values (9) 9 3.4%
 
(Missing) 229 86.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 9 3.4%
 
1.666666667 1 0.4%
 
2 8 3.0%
 
2.2 1 0.4%
 
2.363636364 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
63 1 0.4%
 
49 1 0.4%
 
38.5 1 0.4%
 
25 1 0.4%
 
24 1 0.4%
 

media_funcionarios_coligados_gp
Numeric

Distinct count56
Unique (%)21.1%
Missing (%)76.2%
Missing (n)202
Infinite (%)0.0%
Infinite (n)0
Mean243.245227
Minimum0
Maximum4398.611111
Zeros (%)1.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.1
Q17.666666667
Median45
Q3150
95-th percentile846.658
Maximum4398.611111
Range4398.611111
Interquartile range142.3333333

Descriptive statistics

Standard deviation652.2327083
Coef of variation2.681379266
Kurtosis28.05675891
Mean243.245227
MAD311.8019896
Skewness4.962912511
Sum15324.4493
Variance425407.5058
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
4 4 1.5%
 
0 4 1.5%
 
10 2 0.8%
 
3 2 0.8%
 
25 1 0.4%
 
45 1 0.4%
 
119 1 0.4%
 
28.25 1 0.4%
 
77 1 0.4%
 
37 1 0.4%
 
Other values (45) 45 17.0%
 
(Missing) 202 76.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 4 1.5%
 
1 1 0.4%
 
2 1 0.4%
 
3 2 0.8%
 
4 4 1.5%
 

Maximum 5 values

ValueCountFrequency (%) 
4398.611111 1 0.4%
 
2112 1 0.4%
 
1878.333333 1 0.4%
 
851.4333333 1 0.4%
 
803.68 1 0.4%
 

media_meses_servicos
Numeric

Distinct count265
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean129.43489
Minimum5.947005208
Maximum353.9549383
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum5.947005208
5-th percentile22.16216747
Q158.73533333
Median138.3858912
Q3182.0918301
95-th percentile234.5757388
Maximum353.9549383
Range348.0079331
Interquartile range123.3564967

Descriptive statistics

Standard deviation73.44083954
Coef of variation0.5673960053
Kurtosis-0.6431313459
Mean129.43489
MAD62.156147
Skewness0.1463746749
Sum34300.24586
Variance5393.556912
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 5.94700521 71.14189247 131.75648398 230.94920855 353.95493827], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
47.86570697 1 0.4%
 
146.8411438 1 0.4%
 
152.2654971 1 0.4%
 
30.82928647 1 0.4%
 
223.3868766 1 0.4%
 
235.2654229 1 0.4%
 
160.5006369 1 0.4%
 
58.73533333 1 0.4%
 
99.72819549 1 0.4%
 
121.8192187 1 0.4%
 
Other values (255) 255 96.2%
 

Minimum 5 values

ValueCountFrequency (%) 
5.947005208 1 0.4%
 
10.96567901 1 0.4%
 
11.98393574 1 0.4%
 
14.42028986 1 0.4%
 
15.14791667 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
353.9549383 1 0.4%
 
319.0152482 1 0.4%
 
313.4891775 1 0.4%
 
310.8166667 1 0.4%
 
288.7471564 1 0.4%
 

media_meses_servicos_all
Numeric

Distinct count265
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean120.2838588
Minimum6.115453384
Maximum576.6240637
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum6.115453384
5-th percentile16.11094299
Q139.68535147
Median110.7311828
Q3173.4749593
95-th percentile260.4524049
Maximum576.6240637
Range570.5086103
Interquartile range133.7896079

Descriptive statistics

Standard deviation92.93103827
Coef of variation0.7725977467
Kurtosis3.980982333
Mean120.2838588
MAD71.72502269
Skewness1.453669429
Sum31875.22258
Variance8636.177875
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 6.11545338 40.25856594 226.94763241 288.83190072 576.62406367], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
295.4055381 1 0.4%
 
43.00790988 1 0.4%
 
43.70350877 1 0.4%
 
177.7679012 1 0.4%
 
10.88125 1 0.4%
 
35.87798085 1 0.4%
 
192.4009315 1 0.4%
 
93.25028011 1 0.4%
 
137.1910522 1 0.4%
 
30.17237164 1 0.4%
 
Other values (255) 255 96.2%
 

Minimum 5 values

ValueCountFrequency (%) 
6.115453384 1 0.4%
 
8.896975875 1 0.4%
 
8.910264947 1 0.4%
 
9.274385965 1 0.4%
 
10.88125 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
576.6240637 1 0.4%
 
552.7651578 1 0.4%
 
519.2097977 1 0.4%
 
367.717433 1 0.4%
 
361.3688113 1 0.4%
 

media_vl_folha_coligados
Numeric

Distinct count57
Unique (%)21.5%
Missing (%)78.1%
Missing (n)207
Infinite (%)0.0%
Infinite (n)0
Mean9142780.315
Minimum0
Maximum123432336
Zeros (%)0.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile141153.8371
Q1489402
Median4234615.3
Q310169258.7
95-th percentile26650521.97
Maximum123432336
Range123432336
Interquartile range9679856.695

Descriptive statistics

Standard deviation17729689.14
Coef of variation1.939201045
Kurtosis30.81501375
Mean9142780.315
MAD9466681.82
Skewness5.006155602
Sum530281258.2
Variance3.143418771e+14
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
247276.7969 3 1.1%
 
597585.625 1 0.4%
 
216367.1953 1 0.4%
 
4244918.6 1 0.4%
 
4224312 1 0.4%
 
13991745.79 1 0.4%
 
2720044.75 1 0.4%
 
5472716.419 1 0.4%
 
61819.19922 1 0.4%
 
36695875.81 1 0.4%
 
Other values (46) 46 17.4%
 
(Missing) 207 78.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.4%
 
61819.19922 1 0.4%
 
123638.3984 1 0.4%
 
144244.7969 1 0.4%
 
185457.5938 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
123432336 1 0.4%
 
38369116 1 0.4%
 
36695875.81 1 0.4%
 
24877812.46 1 0.4%
 
24383431.91 1 0.4%
 

media_vl_folha_coligados_gp
Numeric

Distinct count58
Unique (%)21.9%
Missing (%)77.7%
Missing (n)206
Infinite (%)0.0%
Infinite (n)0
Mean14371416.38
Minimum61819.19922
Maximum123432336
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819.19922
5-th percentile181336.3141
Q1723799.7866
Median4718865.566
Q311292306.88
95-th percentile63808925.32
Maximum123432336
Range123370516.8
Interquartile range10568507.09

Descriptive statistics

Standard deviation25761432.24
Coef of variation1.792546507
Kurtosis8.032650745
Mean14371416.38
MAD16632802.19
Skewness2.787974974
Sum847913566.5
Variance6.636513912e+14
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
247276.7969 3 1.1%
 
20716300.79 1 0.4%
 
8531050 1 0.4%
 
783043.1875 1 0.4%
 
18126763.12 1 0.4%
 
216367.1953 1 0.4%
 
61812331.12 1 0.4%
 
2720044.75 1 0.4%
 
61819.19922 1 0.4%
 
8798932.779 1 0.4%
 
Other values (47) 47 17.7%
 
(Missing) 206 77.7%
 

Minimum 5 values

ValueCountFrequency (%) 
61819.19922 1 0.4%
 
123638.3984 1 0.4%
 
144244.7969 1 0.4%
 
185457.5938 1 0.4%
 
216367.1953 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
123432336 1 0.4%
 
110241817.5 1 0.4%
 
81778273.11 1 0.4%
 
61812331.12 1 0.4%
 
52856273.81 1 0.4%
 

meses_ultima_contratacaco
Numeric

Distinct count137
Unique (%)51.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean19.38792453
Minimum1.966666667
Maximum112.1666667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.966666667
5-th percentile2.066666667
Q12.933333333
Median23.2
Q327.9
95-th percentile42.51333333
Maximum112.1666667
Range110.2
Interquartile range24.96666667

Descriptive statistics

Standard deviation16.07359668
Coef of variation0.8290519522
Kurtosis4.60609407
Mean19.38792453
MAD12.8650566
Skewness1.295618532
Sum5137.8
Variance258.3605102
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1.96666667 3.06666667 4.98333333 22.18333333 23.18333333 ... 25.06666667 25.25 31.56666667 46.53333333 112.16666667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2.933333333 16 6.0%
 
23.2 13 4.9%
 
24.2 10 3.8%
 
2.066666667 10 3.8%
 
2.3 7 2.6%
 
30.33333333 6 2.3%
 
2.533333333 6 2.3%
 
2.2 5 1.9%
 
2.033333333 5 1.9%
 
28.3 5 1.9%
 
Other values (127) 182 68.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1.966666667 3 1.1%
 
2 1 0.4%
 
2.033333333 5 1.9%
 
2.066666667 10 3.8%
 
2.166666667 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
112.1666667 1 0.4%
 
88.16666667 1 0.4%
 
70.86666667 1 0.4%
 
68.9 1 0.4%
 
65.83333333 1 0.4%
 

min_faturamento_est_coligados
Numeric

Distinct count26
Unique (%)9.8%
Missing (%)72.1%
Missing (n)191
Infinite (%)0.0%
Infinite (n)0
Mean1901396.8
Minimum50000
Maximum32506596
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum50000
5-th percentile123638.4
Q1210000
Median210000
Q3494553.6
95-th percentile16595879.4
Maximum32506596
Range32456596
Interquartile range284553.6

Descriptive statistics

Standard deviation5720661.001
Coef of variation3.008662369
Kurtosis15.21235622
Mean1901396.8
MAD2850976.173
Skewness3.898271231
Sum140703363.2
Variance3.272596229e+13
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%) 
210000 39 14.7%
 
123638.4 8 3.0%
 
494553.6 3 1.1%
 
618192 2 0.8%
 
930000 2 0.8%
 
21327624 1 0.4%
 
1195171.2 1 0.4%
 
3008534.5 1 0.4%
 
32506596 1 0.4%
 
16433604 1 0.4%
 
Other values (15) 15 5.7%
 
(Missing) 191 72.1%
 

Minimum 5 values

ValueCountFrequency (%) 
50000 1 0.4%
 
123638.4 8 3.0%
 
164851.2 1 0.4%
 
185457.6 1 0.4%
 
206064 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
32506596 1 0.4%
 
23182200 1 0.4%
 
21327624 1 0.4%
 
16897248 1 0.4%
 
16433604 1 0.4%
 

min_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis

Correlation0.9844779291

min_filiais_coligados
Numeric

Distinct count8
Unique (%)3.0%
Missing (%)86.4%
Missing (n)229
Infinite (%)0.0%
Infinite (n)0
Mean2.972222222
Minimum1
Maximum49
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile5.25
Maximum49
Range48
Interquartile range1

Descriptive statistics

Standard deviation7.983862692
Coef of variation2.686159411
Kurtosis34.19743454
Mean2.972222222
MAD2.899691358
Skewness5.787633327
Sum107
Variance63.74206349
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
1 24 9.1%
 
2 5 1.9%
 
3 3 1.1%
 
49 1 0.4%
 
4 1 0.4%
 
6 1 0.4%
 
5 1 0.4%
 
(Missing) 229 86.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 24 9.1%
 
2 5 1.9%
 
3 3 1.1%
 
4 1 0.4%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
49 1 0.4%
 
6 1 0.4%
 
5 1 0.4%
 
4 1 0.4%
 
3 3 1.1%
 

min_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with min_filiais_coligados and should be ignored for analysis

Correlation0.916066893

min_meses_servicos
Highly correlated

This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis

Correlation0.9567491686

min_meses_servicos_all
Numeric

Distinct count125
Unique (%)47.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.331194969
Minimum-11.7
Maximum66.93333333
Zeros (%)7.2%
Mini histogram

Quantile statistics

Minimum-11.7
5-th percentile-6.1
Q1-0.6333333333
Median0
Q31.666666667
95-th percentile10.87333333
Maximum66.93333333
Range78.63333333
Interquartile range2.3

Descriptive statistics

Standard deviation7.099983375
Coef of variation5.333541324
Kurtosis33.65754482
Mean1.331194969
MAD3.590815237
Skewness4.578945101
Sum352.7666667
Variance50.40976393
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-1.17000000e+01 -1.15000000e+00 -7.50000000e-01 -5.00000000e-02 6.66666667e-02 9.66666667e-01 1.05000000e+00 3.13333333e+00 1.28500000e+01 6.69333333e+01], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 19 7.2%
 
1 14 5.3%
 
-0.5333333333 9 3.4%
 
-0.03333333333 8 3.0%
 
-0.7333333333 6 2.3%
 
0.2 6 2.3%
 
2.033333333 5 1.9%
 
-0.4 5 1.9%
 
8.133333333 5 1.9%
 
3.033333333 4 1.5%
 
Other values (115) 184 69.4%
 

Minimum 5 values

ValueCountFrequency (%) 
-11.7 1 0.4%
 
-11.2 2 0.8%
 
-11.16666667 1 0.4%
 
-10.16666667 1 0.4%
 
-9.833333333 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
66.93333333 1 0.4%
 
44.2 1 0.4%
 
27.7 1 0.4%
 
27.5 1 0.4%
 
26.7 1 0.4%
 

min_vl_folha_coligados
Highly correlated

This variable is highly correlated with min_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9989755332

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis

Correlation0.9991732114

natureza_juridica_macro
Categorical

Distinct count4
Unique (%)1.5%
Missing (%)0.0%
Missing (n)0
OUTROS
128
ENTIDADES EMPRESARIAIS
73
ADMINISTRACAO PUBLICA
47
ValueCountFrequency (%) 
OUTROS 128 48.3%
 
ENTIDADES EMPRESARIAIS 73 27.5%
 
ADMINISTRACAO PUBLICA 47 17.7%
 
ENTIDADES SEM FINS LUCRATIVOS 17 6.4%
 
Max length29
Mean length14.54339623
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count26
Unique (%)9.8%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL
150
EDUCACAO
 
22
SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS
 
18
Other values (23)
75
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL 150 56.6%
 
EDUCACAO 22 8.3%
 
SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS 18 6.8%
 
ATIVIDADES DE ATENCAO A SAUDE HUMANA 12 4.5%
 
TRANSPORTE TERRESTRE 12 4.5%
 
SELECAO AGENCIAMENTO E LOCACAO DE MAO DE OBRA 6 2.3%
 
SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICAS 4 1.5%
 
ALIMENTACAO 4 1.5%
 
ATIVIDADES DE VIGILANCIA SEGURANCA E INVESTIGACAO 4 1.5%
 
SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS 4 1.5%
 
Other values (16) 29 10.9%
 
Max length120
Mean length43.50943396
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count20
Unique (%)7.5%
Missing (%)9.1%
Missing (n)24
NORTE MARANHENSE
41
CENTRO AMAZONENSE
39
CENTRO NORTE PIAUIENSE
31
Other values (16)
130
(Missing)
 
24
ValueCountFrequency (%) 
NORTE MARANHENSE 41 15.5%
 
CENTRO AMAZONENSE 39 14.7%
 
CENTRO NORTE PIAUIENSE 31 11.7%
 
LESTE POTIGUAR 23 8.7%
 
VALE DO ACRE 21 7.9%
 
OESTE POTIGUAR 13 4.9%
 
SUDESTE PIAUIENSE 11 4.2%
 
CENTRO MARANHENSE 11 4.2%
 
OESTE MARANHENSE 10 3.8%
 
AGRESTE POTIGUAR 8 3.0%
 
Other values (9) 33 12.5%
 
(Missing) 24 9.1%
 
Max length22
Mean length15.16226415
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count57
Unique (%)21.5%
Missing (%)9.1%
Missing (n)24
MANAUS
38
AGLOMERACAO URBANA DE SAO LUIS
32
TERESINA
 
21
Other values (53)
150
(Missing)
 
24
ValueCountFrequency (%) 
MANAUS 38 14.3%
 
AGLOMERACAO URBANA DE SAO LUIS 32 12.1%
 
TERESINA 21 7.9%
 
RIO BRANCO 19 7.2%
 
NATAL 18 6.8%
 
MEDIO MEARIM 6 2.3%
 
PINDARE 6 2.3%
 
PICOS 6 2.3%
 
ALTO MEDIO CANINDE 5 1.9%
 
CAMPO MAIOR 5 1.9%
 
Other values (46) 85 32.1%
 
(Missing) 24 9.1%
 
Max length30
Mean length12.34716981
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count13
Unique (%)4.9%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL
150
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES
35
EDUCACAO
 
22
Other values (10)
58
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL 150 56.6%
 
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES 35 13.2%
 
EDUCACAO 22 8.3%
 
SAUDE HUMANA E SERVICOS SOCIAIS 14 5.3%
 
TRANSPORTE ARMAZENAGEM E CORREIO 14 5.3%
 
AGUA ESGOTO ATIVIDADES DE GESTAO DE RESIDUOS E DESCONTAMINACAO 5 1.9%
 
ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS RELACIONADOS 5 1.9%
 
ALOJAMENTO E ALIMENTACAO 5 1.9%
 
ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS 5 1.9%
 
OUTRAS ATIVIDADES DE SERVICOS 4 1.5%
 
Other values (3) 6 2.3%
 
Max length62
Mean length42.62641509
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count12
Unique (%)4.5%
Missing (%)0.4%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean24.73863636
Minimum9
Maximum49
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum9
5-th percentile22
Q123
Median23
Q323
95-th percentile48
Maximum49
Range40
Interquartile range0

Descriptive statistics

Standard deviation6.241333431
Coef of variation0.2522909242
Kurtosis9.907271187
Mean24.73863636
MAD3.192493113
Skewness3.29038472
Sum6531
Variance38.954243
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%) 
23 205 77.4%
 
48 15 5.7%
 
26 13 4.9%
 
22 12 4.5%
 
24 7 2.6%
 
27 4 1.5%
 
21 3 1.1%
 
25 2 0.8%
 
9 1 0.4%
 
47 1 0.4%
 

Minimum 5 values

ValueCountFrequency (%) 
9 1 0.4%
 
21 3 1.1%
 
22 12 4.5%
 
23 205 77.4%
 
24 7 2.6%
 

Maximum 5 values

ValueCountFrequency (%) 
49 1 0.4%
 
48 15 5.7%
 
47 1 0.4%
 
27 4 1.5%
 
26 13 4.9%
 

percent_func_genero_fem
Numeric

Distinct count261
Unique (%)98.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean52.97943396
Minimum0.36
Maximum86.06
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.36
5-th percentile13.274
Q143.38
Median57.51
Q367.71
95-th percentile76.994
Maximum86.06
Range85.7
Interquartile range24.33

Descriptive statistics

Standard deviation19.04481282
Coef of variation0.3594755814
Kurtosis0.1213098667
Mean52.97943396
MAD15.19650267
Skewness-0.8547835709
Sum14039.55
Variance362.7048955
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0.36 30.935 47.245 73.815 86.06 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
63.38 2 0.8%
 
72.93 2 0.8%
 
69.21 2 0.8%
 
50 2 0.8%
 
68.02 1 0.4%
 
49.35 1 0.4%
 
52.31 1 0.4%
 
68.63 1 0.4%
 
63.36 1 0.4%
 
74.03 1 0.4%
 
Other values (251) 251 94.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0.36 1 0.4%
 
3 1 0.4%
 
3.47 1 0.4%
 
4.74 1 0.4%
 
4.98 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
86.06 1 0.4%
 
84.44 1 0.4%
 
83.22 1 0.4%
 
83.1 1 0.4%
 
82.91 1 0.4%
 

percent_func_genero_masc
Numeric

Distinct count261
Unique (%)98.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean47.02056604
Minimum13.94
Maximum99.64
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum13.94
5-th percentile23.006
Q132.29
Median42.49
Q356.62
95-th percentile86.726
Maximum99.64
Range85.7
Interquartile range24.33

Descriptive statistics

Standard deviation19.04481282
Coef of variation0.4050315517
Kurtosis0.1213098667
Mean47.02056604
MAD15.19650267
Skewness0.8547835709
Sum12460.45
Variance362.7048955
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[13.94 26.185 52.755 69.065 99.64 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
27.07 2 0.8%
 
36.62 2 0.8%
 
30.79 2 0.8%
 
50 2 0.8%
 
52.76 1 0.4%
 
16.78 1 0.4%
 
64.01 1 0.4%
 
74.22 1 0.4%
 
36.64 1 0.4%
 
50.65 1 0.4%
 
Other values (251) 251 94.7%
 

Minimum 5 values

ValueCountFrequency (%) 
13.94 1 0.4%
 
15.56 1 0.4%
 
16.78 1 0.4%
 
16.9 1 0.4%
 
17.09 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
99.64 1 0.4%
 
97 1 0.4%
 
96.53 1 0.4%
 
95.26 1 0.4%
 
95.02 1 0.4%
 

qt_admitidos
Numeric

Distinct count241
Unique (%)90.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean915.8641509
Minimum83
Maximum7961
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum83
5-th percentile177
Q1355
Median582
Q3983
95-th percentile2839.4
Maximum7961
Range7878
Interquartile range628

Descriptive statistics

Standard deviation1092.19591
Coef of variation1.192530474
Kurtosis16.81983238
Mean915.8641509
MAD641.1677892
Skewness3.67572609
Sum242704
Variance1192891.906
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 83. 590.5 1045.5 1770. 3398.5 7961. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
246 2 0.8%
 
582 2 0.8%
 
1044 2 0.8%
 
410 2 0.8%
 
355 2 0.8%
 
1484 2 0.8%
 
1160 2 0.8%
 
1212 2 0.8%
 
340 2 0.8%
 
243 2 0.8%
 
Other values (231) 245 92.5%
 

Minimum 5 values

ValueCountFrequency (%) 
83 1 0.4%
 
96 1 0.4%
 
120 1 0.4%
 
130 1 0.4%
 
136 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
7961 1 0.4%
 
7803 1 0.4%
 
6262 1 0.4%
 
6103 1 0.4%
 
5340 1 0.4%
 

qt_admitidos_12meses
Numeric

Distinct count73
Unique (%)27.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean28.06415094
Minimum0
Maximum782
Zeros (%)61.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q327
95-th percentile132.2
Maximum782
Range782
Interquartile range27

Descriptive statistics

Standard deviation73.04087454
Coef of variation2.602639741
Kurtosis48.79607181
Mean28.06415094
MAD38.54211463
Skewness5.908751273
Sum7437
Variance5334.969354
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 3.850e+01 9.850e+01 2.575e+02 7.820e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 162 61.1%
 
35 3 1.1%
 
8 3 1.1%
 
1 3 1.1%
 
18 3 1.1%
 
87 3 1.1%
 
13 3 1.1%
 
12 3 1.1%
 
74 2 0.8%
 
14 2 0.8%
 
Other values (63) 78 29.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 162 61.1%
 
1 3 1.1%
 
2 2 0.8%
 
4 1 0.4%
 
6 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
782 1 0.4%
 
465 1 0.4%
 
332 1 0.4%
 
259 1 0.4%
 
256 1 0.4%
 

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_art
Numeric

Distinct count39
Unique (%)14.7%
Missing (%)50.9%
Missing (n)135
Infinite (%)0.0%
Infinite (n)0
Mean21.51538462
Minimum1
Maximum912
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12.25
Median6
Q314
95-th percentile44
Maximum912
Range911
Interquartile range11.75

Descriptive statistics

Standard deviation87.8001814
Coef of variation4.080809289
Kurtosis86.51934653
Mean21.51538462
MAD25.25633136
Skewness8.982447187
Sum2797
Variance7708.871855
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%) 
1 20 7.5%
 
3 13 4.9%
 
2 13 4.9%
 
6 10 3.8%
 
5 9 3.4%
 
13 6 2.3%
 
7 6 2.3%
 
4 5 1.9%
 
14 4 1.5%
 
12 3 1.1%
 
Other values (28) 41 15.5%
 
(Missing) 135 50.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 20 7.5%
 
2 13 4.9%
 
3 13 4.9%
 
4 5 1.9%
 
5 9 3.4%
 

Maximum 5 values

ValueCountFrequency (%) 
912 1 0.4%
 
426 1 0.4%
 
88 1 0.4%
 
51 2 0.8%
 
45 1 0.4%
 

qt_coligadas
Numeric

Distinct count21
Unique (%)7.9%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean6.973684211
Minimum1
Maximum57
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q36
95-th percentile36.5
Maximum57
Range56
Interquartile range5

Descriptive statistics

Standard deviation11.02962518
Coef of variation1.581606629
Kurtosis7.083269653
Mean6.973684211
MAD7.274930748
Skewness2.633455034
Sum530
Variance121.6526316
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%) 
1 27 10.2%
 
2 14 5.3%
 
3 7 2.6%
 
6 7 2.6%
 
4 3 1.1%
 
15 2 0.8%
 
8 2 0.8%
 
17 2 0.8%
 
9 1 0.4%
 
36 1 0.4%
 
Other values (10) 10 3.8%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 27 10.2%
 
2 14 5.3%
 
3 7 2.6%
 
4 3 1.1%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
57 1 0.4%
 
40 1 0.4%
 
39 1 0.4%
 
38 1 0.4%
 
36 1 0.4%
 

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation1

qt_coligados_agropecuaria
Categorical

Distinct count5
Unique (%)1.9%
Missing (%)71.3%
Missing (n)189
0
70
1
 
3
2
 
2
(Missing)
189
ValueCountFrequency (%) 
0 70 26.4%
 
1 3 1.1%
 
2 2 0.8%
 
4 1 0.4%
 
(Missing) 189 71.3%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_atividade_alto
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)71.3%
Missing (n)189
0
76
(Missing)
189
ValueCountFrequency (%) 
0 76 28.7%
 
(Missing) 189 71.3%
 

qt_coligados_atividade_baixo
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)71.3%
Missing (n)189
0
76
(Missing)
189
ValueCountFrequency (%) 
0 76 28.7%
 
(Missing) 189 71.3%
 

qt_coligados_atividade_inativo
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)71.3%
Missing (n)189
0
76
(Missing)
189
ValueCountFrequency (%) 
0 76 28.7%
 
(Missing) 189 71.3%
 

qt_coligados_atividade_medio
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)71.3%
Missing (n)189
0
76
(Missing)
189
ValueCountFrequency (%) 
0 76 28.7%
 
(Missing) 189 71.3%
 

qt_coligados_atividade_mt_baixo
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)71.3%
Missing (n)189
0
76
(Missing)
189
ValueCountFrequency (%) 
0 76 28.7%
 
(Missing) 189 71.3%
 

qt_coligados_ativo
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation0.9997516702

qt_coligados_baixada
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9718460044

qt_coligados_ccivil
Categorical

Distinct count5
Unique (%)1.9%
Missing (%)71.3%
Missing (n)189
0
68
1
 
5
2
 
2
(Missing)
189
ValueCountFrequency (%) 
0 68 25.7%
 
1 5 1.9%
 
2 2 0.8%
 
3 1 0.4%
 
(Missing) 189 71.3%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_centro
Numeric

Distinct count6
Unique (%)2.3%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean0.3157894737
Minimum0
Maximum8
Zeros (%)25.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum8
Range8
Interquartile range0

Descriptive statistics

Standard deviation1.298311995
Coef of variation4.111321316
Kurtosis25.69387946
Mean0.3157894737
MAD0.5650969529
Skewness5.017307957
Sum24
Variance1.685614035
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 68 25.7%
 
1 5 1.9%
 
8 1 0.4%
 
4 1 0.4%
 
7 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 68 25.7%
 
1 5 1.9%
 
4 1 0.4%
 
7 1 0.4%
 
8 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 0.4%
 
7 1 0.4%
 
4 1 0.4%
 
1 5 1.9%
 
0 68 25.7%
 

qt_coligados_comercio
Numeric

Distinct count9
Unique (%)3.4%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean1.092105263
Minimum0
Maximum26
Zeros (%)17.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile4
Maximum26
Range26
Interquartile range1

Descriptive statistics

Standard deviation3.154584522
Coef of variation2.888535225
Kurtosis53.16937363
Mean1.092105263
MAD1.355955679
Skewness6.822610724
Sum83
Variance9.951403509
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
0 46 17.4%
 
1 14 5.3%
 
2 9 3.4%
 
4 2 0.8%
 
3 2 0.8%
 
6 1 0.4%
 
5 1 0.4%
 
26 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 46 17.4%
 
1 14 5.3%
 
2 9 3.4%
 
3 2 0.8%
 
4 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
26 1 0.4%
 
6 1 0.4%
 
5 1 0.4%
 
4 2 0.8%
 
3 2 0.8%
 

qt_coligados_epp
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)71.3%
Missing (n)189
0
76
(Missing)
189
ValueCountFrequency (%) 
0 76 28.7%
 
(Missing) 189 71.3%
 

qt_coligados_exterior
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)71.3%
Missing (n)189
0
76
(Missing)
189
ValueCountFrequency (%) 
0 76 28.7%
 
(Missing) 189 71.3%
 

qt_coligados_inapta
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9718460044

qt_coligados_industria
Numeric

Distinct count8
Unique (%)3.0%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean0.4473684211
Minimum0
Maximum10
Zeros (%)23.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2.25
Maximum10
Range10
Interquartile range0

Descriptive statistics

Standard deviation1.491261094
Coef of variation3.33340715
Kurtosis25.37777825
Mean0.4473684211
MAD0.7416897507
Skewness4.762327507
Sum34
Variance2.223859649
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
0 63 23.8%
 
1 8 3.0%
 
10 1 0.4%
 
3 1 0.4%
 
2 1 0.4%
 
5 1 0.4%
 
6 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 63 23.8%
 
1 8 3.0%
 
2 1 0.4%
 
3 1 0.4%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
10 1 0.4%
 
6 1 0.4%
 
5 1 0.4%
 
3 1 0.4%
 
2 1 0.4%
 

qt_coligados_ltda
Numeric

Distinct count6
Unique (%)2.3%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean0.2631578947
Minimum0
Maximum8
Zeros (%)26.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum8
Range8
Interquartile range0

Descriptive statistics

Standard deviation1.170395045
Coef of variation4.447501171
Kurtosis32.87682671
Mean0.2631578947
MAD0.4778393352
Skewness5.61595368
Sum20
Variance1.369824561
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 69 26.0%
 
1 4 1.5%
 
2 1 0.4%
 
8 1 0.4%
 
6 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 69 26.0%
 
1 4 1.5%
 
2 1 0.4%
 
6 1 0.4%
 
8 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 0.4%
 
6 1 0.4%
 
2 1 0.4%
 
1 4 1.5%
 
0 69 26.0%
 

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.9996971343

qt_coligados_me
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)71.3%
Missing (n)189
0
76
(Missing)
189
ValueCountFrequency (%) 
0 76 28.7%
 
(Missing) 189 71.3%
 

qt_coligados_mei
Boolean

Distinct count3
Unique (%)1.1%
Missing (%)71.3%
Missing (n)189
0
75
1
 
1
(Missing)
189
ValueCountFrequency (%) 
0 75 28.3%
 
1 1 0.4%
 
(Missing) 189 71.3%
 

qt_coligados_nordeste
Numeric

Distinct count14
Unique (%)5.3%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean2.618421053
Minimum0
Maximum36
Zeros (%)11.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32.25
95-th percentile9.75
Maximum36
Range36
Interquartile range2.25

Descriptive statistics

Standard deviation5.53767004
Coef of variation2.114889061
Kurtosis20.6502858
Mean2.618421053
MAD3.006578947
Skewness4.20720687
Sum199
Variance30.66578947
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%) 
0 31 11.7%
 
1 17 6.4%
 
2 9 3.4%
 
6 4 1.5%
 
3 4 1.5%
 
4 4 1.5%
 
36 1 0.4%
 
25 1 0.4%
 
12 1 0.4%
 
5 1 0.4%
 
Other values (3) 3 1.1%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 31 11.7%
 
1 17 6.4%
 
2 9 3.4%
 
3 4 1.5%
 
4 4 1.5%
 

Maximum 5 values

ValueCountFrequency (%) 
36 1 0.4%
 
25 1 0.4%
 
17 1 0.4%
 
12 1 0.4%
 
9 1 0.4%
 

qt_coligados_norte
Numeric

Distinct count14
Unique (%)5.3%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean2.881578947
Minimum0
Maximum52
Zeros (%)14.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q32
95-th percentile11.75
Maximum52
Range52
Interquartile range2

Descriptive statistics

Standard deviation7.575340882
Coef of variation2.62888542
Kurtosis26.25778584
Mean2.881578947
MAD3.789819945
Skewness4.775758542
Sum219
Variance57.38578947
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%) 
0 39 14.7%
 
1 14 5.3%
 
2 6 2.3%
 
5 3 1.1%
 
3 3 1.1%
 
4 2 0.8%
 
9 2 0.8%
 
6 2 0.8%
 
22 1 0.4%
 
11 1 0.4%
 
Other values (3) 3 1.1%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 39 14.7%
 
1 14 5.3%
 
2 6 2.3%
 
3 3 1.1%
 
4 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
52 1 0.4%
 
32 1 0.4%
 
22 1 0.4%
 
14 1 0.4%
 
11 1 0.4%
 

qt_coligados_nula
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)71.3%
Missing (n)189
0
76
(Missing)
189
ValueCountFrequency (%) 
0 76 28.7%
 
(Missing) 189 71.3%
 

qt_coligados_sa
Numeric

Distinct count7
Unique (%)2.6%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean0.5394736842
Minimum0
Maximum10
Zeros (%)24.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile4
Maximum10
Range10
Interquartile range0

Descriptive statistics

Standard deviation1.700515918
Coef of variation3.152175847
Kurtosis16.01041505
Mean0.5394736842
MAD0.9085872576
Skewness3.882045201
Sum41
Variance2.891754386
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
0 64 24.2%
 
1 6 2.3%
 
4 3 1.1%
 
10 1 0.4%
 
7 1 0.4%
 
6 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 64 24.2%
 
1 6 2.3%
 
4 3 1.1%
 
6 1 0.4%
 
7 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
10 1 0.4%
 
7 1 0.4%
 
6 1 0.4%
 
4 3 1.1%
 
1 6 2.3%
 

qt_coligados_serviço
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.9288399907

qt_coligados_sudeste
Numeric

Distinct count9
Unique (%)3.4%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean1.013157895
Minimum0
Maximum28
Zeros (%)24.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile3.75
Maximum28
Range28
Interquartile range0

Descriptive statistics

Standard deviation4.067737851
Coef of variation4.014910087
Kurtosis31.87862308
Mean1.013157895
MAD1.733379501
Skewness5.47611395
Sum77
Variance16.54649123
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
0 65 24.5%
 
2 4 1.5%
 
3 2 0.8%
 
1 1 0.4%
 
8 1 0.4%
 
6 1 0.4%
 
28 1 0.4%
 
20 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 65 24.5%
 
1 1 0.4%
 
2 4 1.5%
 
3 2 0.8%
 
6 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
28 1 0.4%
 
20 1 0.4%
 
8 1 0.4%
 
6 1 0.4%
 
3 2 0.8%
 

qt_coligados_sul
Highly correlated

This variable is highly correlated with qt_coligados_baixada and should be ignored for analysis

Correlation0.9612903226

qt_coligados_suspensa
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)71.3%
Missing (n)189
0
76
(Missing)
189
ValueCountFrequency (%) 
0 76 28.7%
 
(Missing) 189 71.3%
 

qt_desligados
Highly correlated

This variable is highly correlated with qt_admitidos and should be ignored for analysis

Correlation0.905610227

qt_desligados_12meses
Numeric

Distinct count73
Unique (%)27.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean23.92075472
Minimum0
Maximum394
Zeros (%)60.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q321
95-th percentile125.6
Maximum394
Range394
Interquartile range21

Descriptive statistics

Standard deviation59.92998869
Coef of variation2.505355262
Kurtosis18.14991854
Mean23.92075472
MAD32.95723745
Skewness4.020251455
Sum6339
Variance3591.603545
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 29.5 71. 394. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 159 60.0%
 
27 6 2.3%
 
9 5 1.9%
 
8 4 1.5%
 
22 4 1.5%
 
29 3 1.1%
 
7 3 1.1%
 
1 3 1.1%
 
11 3 1.1%
 
5 3 1.1%
 
Other values (63) 72 27.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 159 60.0%
 
1 3 1.1%
 
2 1 0.4%
 
3 2 0.8%
 
4 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
394 1 0.4%
 
379 1 0.4%
 
366 1 0.4%
 
345 1 0.4%
 
277 1 0.4%
 

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation0.9999991015

qt_filiais
Numeric

Distinct count21
Unique (%)7.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.554716981
Minimum0
Maximum172
Zeros (%)58.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile9.8
Maximum172
Range172
Interquartile range1

Descriptive statistics

Standard deviation12.01001107
Coef of variation4.701112162
Kurtosis153.0330249
Mean2.554716981
MAD3.681594874
Skewness11.40867694
Sum677
Variance144.2403659
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=21)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 3.5 16.5 172. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 155 58.5%
 
1 53 20.0%
 
2 17 6.4%
 
3 10 3.8%
 
5 4 1.5%
 
7 3 1.1%
 
4 3 1.1%
 
10 3 1.1%
 
12 2 0.8%
 
9 2 0.8%
 
Other values (11) 13 4.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 155 58.5%
 
1 53 20.0%
 
2 17 6.4%
 
3 10 3.8%
 
4 3 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
172 1 0.4%
 
51 1 0.4%
 
49 1 0.4%
 
42 1 0.4%
 
33 1 0.4%
 

qt_funcionarios
Numeric

Distinct count231
Unique (%)87.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean468.6
Minimum68
Maximum3919
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum68
5-th percentile116
Q1188
Median313
Q3539
95-th percentile1321.2
Maximum3919
Range3851
Interquartile range351

Descriptive statistics

Standard deviation494.5689568
Coef of variation1.055418175
Kurtosis16.01577453
Mean468.6
MAD310.0649057
Skewness3.441655417
Sum124179
Variance244598.453
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 68. 117.5 233.5 549.5 902.5 1927.5 3919. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
349 2 0.8%
 
353 2 0.8%
 
378 2 0.8%
 
677 2 0.8%
 
219 2 0.8%
 
188 2 0.8%
 
186 2 0.8%
 
199 2 0.8%
 
317 2 0.8%
 
212 2 0.8%
 
Other values (221) 245 92.5%
 

Minimum 5 values

ValueCountFrequency (%) 
68 1 0.4%
 
76 1 0.4%
 
82 1 0.4%
 
83 1 0.4%
 
85 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
3919 1 0.4%
 
3172 1 0.4%
 
3104 1 0.4%
 
2669 1 0.4%
 
1936 1 0.4%
 

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation0.9948729203

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation0.968894117

qt_funcionarios_coligados
Numeric

Distinct count53
Unique (%)20.0%
Missing (%)76.2%
Missing (n)202
Infinite (%)0.0%
Infinite (n)0
Mean551.031746
Minimum0
Maximum4770
Zeros (%)1.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q110.5
Median112
Q3510.5
95-th percentile3090.1
Maximum4770
Range4770
Interquartile range500

Descriptive statistics

Standard deviation1079.387595
Coef of variation1.958848292
Kurtosis7.119124121
Mean551.031746
MAD685.382716
Skewness2.731363438
Sum34715
Variance1165077.58
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 5 1.9%
 
4 3 1.1%
 
23 2 0.8%
 
3 2 0.8%
 
1 2 0.8%
 
11 2 0.8%
 
617 2 0.8%
 
54 1 0.4%
 
152 1 0.4%
 
312 1 0.4%
 
Other values (42) 42 15.8%
 
(Missing) 202 76.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5 1.9%
 
1 2 0.8%
 
2 1 0.4%
 
3 2 0.8%
 
4 3 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4770 1 0.4%
 
4463 1 0.4%
 
4124 1 0.4%
 
3183 1 0.4%
 
2254 1 0.4%
 

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with qt_coligados_inapta and should be ignored for analysis

Correlation0.9231363224

qt_funcionarios_grupo
Highly correlated

This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis

Correlation0.9502971077

qt_ramos_coligados
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.9346159264

qt_regioes_coligados
Numeric

Distinct count6
Unique (%)2.3%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean1.407894737
Minimum1
Maximum5
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile4
Maximum5
Range4
Interquartile range0

Descriptive statistics

Standard deviation0.9118133081
Coef of variation0.6476430973
Kurtosis4.718362297
Mean1.407894737
MAD0.6440443213
Skewness2.339935018
Sum107
Variance0.8314035088
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
1 60 22.6%
 
2 7 2.6%
 
3 4 1.5%
 
4 4 1.5%
 
5 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 60 22.6%
 
2 7 2.6%
 
3 4 1.5%
 
4 4 1.5%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 0.4%
 
4 4 1.5%
 
3 4 1.5%
 
2 7 2.6%
 
1 60 22.6%
 

qt_socios
Highly correlated

This variable is highly correlated with qt_coligados_mei and should be ignored for analysis

Correlation0.9899466719

qt_socios_coligados
Numeric

Distinct count23
Unique (%)8.7%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean12.76315789
Minimum1
Maximum138
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q312
95-th percentile58.5
Maximum138
Range137
Interquartile range11

Descriptive statistics

Standard deviation26.83125959
Coef of variation2.102243019
Kurtosis12.26288439
Mean12.76315789
MAD15.08587258
Skewness3.488701101
Sum970
Variance719.9164912
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%) 
1 24 9.1%
 
2 13 4.9%
 
4 5 1.9%
 
3 4 1.5%
 
5 4 1.5%
 
14 3 1.1%
 
6 3 1.1%
 
24 2 0.8%
 
28 2 0.8%
 
12 2 0.8%
 
Other values (12) 14 5.3%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 24 9.1%
 
2 13 4.9%
 
3 4 1.5%
 
4 5 1.9%
 
5 4 1.5%
 

Maximum 5 values

ValueCountFrequency (%) 
138 1 0.4%
 
128 1 0.4%
 
107 1 0.4%
 
96 1 0.4%
 
46 1 0.4%
 

qt_socios_feminino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation0.9936468189

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios_feminino and should be ignored for analysis

Correlation0.9916264524

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation0.9954550751

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.9960939342

qt_socios_pj
Numeric

Distinct count6
Unique (%)2.3%
Missing (%)63.0%
Missing (n)167
Infinite (%)0.0%
Infinite (n)0
Mean0.2551020408
Minimum0
Maximum5
Zeros (%)31.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2
Maximum5
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.7365456361
Coef of variation2.887258893
Kurtosis19.40726857
Mean0.2551020408
MAD0.4321116202
Skewness3.979704856
Sum25
Variance0.542499474
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 83 31.3%
 
1 9 3.4%
 
2 4 1.5%
 
5 1 0.4%
 
3 1 0.4%
 
(Missing) 167 63.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 83 31.3%
 
1 9 3.4%
 
2 4 1.5%
 
3 1 0.4%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 0.4%
 
3 1 0.4%
 
2 4 1.5%
 
1 9 3.4%
 
0 83 31.3%
 

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation1

qt_socios_pj_baixados
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)94.3%
Missing (n)250
0
 
15
(Missing)
250
ValueCountFrequency (%) 
0 15 5.7%
 
(Missing) 250 94.3%
 

qt_socios_pj_inaptos
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)94.3%
Missing (n)250
0
 
15
(Missing)
250
ValueCountFrequency (%) 
0 15 5.7%
 
(Missing) 250 94.3%
 

qt_socios_pj_nulos
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)94.3%
Missing (n)250
0
 
15
(Missing)
250
ValueCountFrequency (%) 
0 15 5.7%
 
(Missing) 250 94.3%
 

qt_socios_pj_suspensos
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)94.3%
Missing (n)250
0
 
15
(Missing)
250
ValueCountFrequency (%) 
0 15 5.7%
 
(Missing) 250 94.3%
 

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation0.9983592345

qt_socios_st_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_ufs_coligados
Highly correlated

This variable is highly correlated with qt_regioes_coligados and should be ignored for analysis

Correlation0.9026409791

setor
Constant

This variable is constant and should be ignored for analysis

Constant valueSERVIÇO

sg_uf
Categorical

Distinct count6
Unique (%)2.3%
Missing (%)0.0%
Missing (n)0
MA
74
PI
52
RN
51
Other values (3)
88
ValueCountFrequency (%) 
MA 74 27.9%
 
PI 52 19.6%
 
RN 51 19.2%
 
AM 43 16.2%
 
AC 23 8.7%
 
RO 22 8.3%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Recoded

This variable is a recoding of sg_uf and should be ignored for analysis

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9016602831

total
Highly correlated

This variable is highly correlated with qt_funcionarios_grupo and should be ignored for analysis

Correlation0.9743124436

total_filiais_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9354643228

tx_crescimento_12meses
Numeric

Distinct count104
Unique (%)39.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean51.83115614
Minimum-29.63265306
Maximum12700
Zeros (%)60.8%
Mini histogram

Quantile statistics

Minimum-29.63265306
5-th percentile-6.509605013
Q10
Median0
Q30
95-th percentile29.53423981
Maximum12700
Range12729.63265
Interquartile range0

Descriptive statistics

Standard deviation780.1739957
Coef of variation15.05222059
Kurtosis264.6427775
Mean51.83115614
MAD97.85147727
Skewness16.26255534
Sum13735.25638
Variance608671.4636
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-2.96326531e+01 -1.45611587e+01 -3.66344006e+00 -7.15307582e-02 1.46627566e-01 6.80991490e+00 2.07987427e+01 8.88235294e+01 1.27000000e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 161 60.8%
 
6.382978723 2 0.8%
 
40.6779661 1 0.4%
 
13.71115174 1 0.4%
 
75.6097561 1 0.4%
 
27.1393643 1 0.4%
 
40.99099099 1 0.4%
 
-9.80861244 1 0.4%
 
-1.45631068 1 0.4%
 
-29.63265306 1 0.4%
 
Other values (94) 94 35.5%
 

Minimum 5 values

ValueCountFrequency (%) 
-29.63265306 1 0.4%
 
-25.87917042 1 0.4%
 
-14.604811 1 0.4%
 
-14.5175064 1 0.4%
 
-13.58024691 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
12700 1 0.4%
 
246.1538462 1 0.4%
 
100 1 0.4%
 
77.64705882 1 0.4%
 
75.6097561 1 0.4%
 

tx_crescimento_24meses
Highly correlated

This variable is highly correlated with tx_crescimento_12meses and should be ignored for analysis

Correlation0.9959598268

tx_rotatividade
Numeric

Distinct count106
Unique (%)40.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean6.566274968
Minimum0
Maximum101.0869565
Zeros (%)60.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q311.39369278
95-th percentile28.69354055
Maximum101.0869565
Range101.0869565
Interquartile range11.39369278

Descriptive statistics

Standard deviation11.82783766
Coef of variation1.801300999
Kurtosis16.07742863
Mean6.566274968
MAD8.611309487
Skewness3.063189929
Sum1740.062866
Variance139.8977438
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 6.69344043e-02 2.31021759e+01 4.14632035e+01 1.01086957e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 160 60.4%
 
9.03696942 1 0.4%
 
36.06557377 1 0.4%
 
40.25974026 1 0.4%
 
2.575107296 1 0.4%
 
4.532577904 1 0.4%
 
18.73605948 1 0.4%
 
34.30232558 1 0.4%
 
4.888888889 1 0.4%
 
9.900990099 1 0.4%
 
Other values (96) 96 36.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 160 60.4%
 
0.1338688086 1 0.4%
 
0.1431639227 1 0.4%
 
0.5611672278 1 0.4%
 
0.8298755187 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
101.0869565 1 0.4%
 
55.35248042 1 0.4%
 
42.66666667 1 0.4%
 
40.25974026 1 0.4%
 
39.18367347 1 0.4%
 

Unnamed_0_x
Numeric

Distinct count265
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean132
Minimum0
Maximum264
Zeros (%)0.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile13.2
Q166
Median132
Q3198
95-th percentile250.8
Maximum264
Range264
Interquartile range132

Descriptive statistics

Standard deviation76.64311232
Coef of variation0.5806296388
Kurtosis-1.2
Mean132
MAD66.2490566
Skewness0
Sum34980
Variance5874.166667
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 264.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
264 1 0.4%
 
82 1 0.4%
 
96 1 0.4%
 
95 1 0.4%
 
94 1 0.4%
 
93 1 0.4%
 
92 1 0.4%
 
91 1 0.4%
 
90 1 0.4%
 
89 1 0.4%
 
Other values (255) 255 96.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.4%
 
1 1 0.4%
 
2 1 0.4%
 
3 1 0.4%
 
4 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
264 1 0.4%
 
263 1 0.4%
 
262 1 0.4%
 
261 1 0.4%
 
260 1 0.4%
 

Unnamed_0_y
Highly correlated

This variable is highly correlated with Unnamed_0_x and should be ignored for analysis

Correlation0.9988970638

vl_faturamento_estimado_aux
Numeric

Distinct count248
Unique (%)93.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean108007862.2
Minimum20039724
Maximum2011596800
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20039724
5-th percentile22584614.4
Q130600504
Median51000840
Q399786500
95-th percentile378652900
Maximum2011596800
Range1991557076
Interquartile range69185996

Descriptive statistics

Standard deviation192627638.9
Coef of variation1.783459417
Kurtosis45.08106971
Mean108007862.2
MAD94175330.34
Skewness5.851507067
Sum2.862208347e+10
Variance3.710540726e+16
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[2.00397240e+07 3.85339680e+07 6.86708350e+07 1.47026665e+08 3.25967480e+08 7.09529855e+08 2.01159680e+09], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
24624648 3 1.1%
 
24882228 2 0.8%
 
49661424 2 0.8%
 
45282564 2 0.8%
 
24418584 2 0.8%
 
23336748 2 0.8%
 
117404960 2 0.8%
 
23388264 2 0.8%
 
27818640 2 0.8%
 
27870156 2 0.8%
 
Other values (238) 244 92.1%
 

Minimum 5 values

ValueCountFrequency (%) 
20039724 1 0.4%
 
20245788 1 0.4%
 
20606400 2 0.8%
 
20709432 1 0.4%
 
20760948 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2011596800 1 0.4%
 
1375889300 1 0.4%
 
930378940 1 0.4%
 
914615040 1 0.4%
 
755585150 1 0.4%
 

vl_faturamento_estimado_grupo_aux
Highly correlated

This variable is highly correlated with vl_faturamento_estimado_aux and should be ignored for analysis

Correlation0.9811022766

vl_folha_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis

Correlation0.961120251

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with vl_folha_coligados and should be ignored for analysis

Correlation0.9428868609

vl_frota
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.9138805515

vl_idade_maxima_socios_pj
Numeric

Distinct count16
Unique (%)6.0%
Missing (%)94.3%
Missing (n)250
Infinite (%)0.0%
Infinite (n)0
Mean24.03741729
Minimum0.7611225188
Maximum52.28199863
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.7611225188
5-th percentile3.229568789
Q19.338809035
Median27.80013689
Q335.41820671
95-th percentile47.39685147
Maximum52.28199863
Range51.52087611
Interquartile range26.07939767

Descriptive statistics

Standard deviation16.28980879
Coef of variation0.6776854846
Kurtosis-1.234614151
Mean24.03741729
MAD14.08228763
Skewness0.1416487434
Sum360.5612594
Variance265.3578703
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%) 
27.80013689 1 0.4%
 
32.94182067 1 0.4%
 
7.882272416 1 0.4%
 
18.33812457 1 0.4%
 
52.28199863 1 0.4%
 
4.287474333 1 0.4%
 
10.79534565 1 0.4%
 
37.89459274 1 0.4%
 
14.28336756 1 0.4%
 
40.98288843 1 0.4%
 
Other values (5) 5 1.9%
 
(Missing) 250 94.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0.7611225188 1 0.4%
 
4.287474333 1 0.4%
 
6.29705681 1 0.4%
 
7.882272416 1 0.4%
 
10.79534565 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
52.28199863 1 0.4%
 
45.30321697 1 0.4%
 
40.98288843 1 0.4%
 
37.89459274 1 0.4%
 
32.94182067 1 0.4%
 

vl_idade_media_socios_pj
Numeric

Distinct count16
Unique (%)6.0%
Missing (%)94.3%
Missing (n)250
Infinite (%)0.0%
Infinite (n)0
Mean17.75692144
Minimum0.7611225188
Maximum40.98288843
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.7611225188
5-th percentile3.229568789
Q19.338809035
Median15.05087839
Q327.46817248
95-th percentile35.354141
Maximum40.98288843
Range40.22176591
Interquartile range18.12936345

Descriptive statistics

Standard deviation11.97944205
Coef of variation0.6746350763
Kurtosis-0.7206734384
Mean17.75692144
MAD9.726381626
Skewness0.5442538678
Sum266.3538216
Variance143.5070318
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%) 
32.94182067 1 0.4%
 
7.882272416 1 0.4%
 
18.33812457 1 0.4%
 
15.05087839 1 0.4%
 
32.29021218 1 0.4%
 
4.287474333 1 0.4%
 
15.93839836 1 0.4%
 
10.79534565 1 0.4%
 
14.28336756 1 0.4%
 
23.5742642 1 0.4%
 
Other values (5) 5 1.9%
 
(Missing) 250 94.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0.7611225188 1 0.4%
 
4.287474333 1 0.4%
 
6.29705681 1 0.4%
 
7.882272416 1 0.4%
 
10.79534565 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
40.98288843 1 0.4%
 
32.94182067 1 0.4%
 
32.29021218 1 0.4%
 
31.36208077 1 0.4%
 
23.5742642 1 0.4%
 

vl_idade_minima_socios_pj
Numeric

Distinct count16
Unique (%)6.0%
Missing (%)94.3%
Missing (n)250
Infinite (%)0.0%
Infinite (n)0
Mean13.75952544
Minimum0.6598220397
Maximum40.98288843
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.6598220397
5-th percentile0.7307323751
Q13.957563313
Median10.79534565
Q318.84325804
95-th percentile35.354141
Maximum40.98288843
Range40.32306639
Interquartile range14.88569473

Descriptive statistics

Standard deviation12.62551595
Coef of variation0.9175836775
Kurtosis0.03197410952
Mean13.75952544
MAD9.959936117
Skewness1.005764265
Sum206.3928816
Variance159.4036531
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%) 
32.94182067 1 0.4%
 
7.882272416 1 0.4%
 
12.29842574 1 0.4%
 
18.33812457 1 0.4%
 
4.287474333 1 0.4%
 
0.6598220397 1 0.4%
 
10.79534565 1 0.4%
 
14.28336756 1 0.4%
 
40.98288843 1 0.4%
 
31.36208077 1 0.4%
 
Other values (5) 5 1.9%
 
(Missing) 250 94.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0.6598220397 1 0.4%
 
0.7611225188 1 0.4%
 
2.527036277 1 0.4%
 
3.627652293 1 0.4%
 
4.287474333 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
40.98288843 1 0.4%
 
32.94182067 1 0.4%
 
31.36208077 1 0.4%
 
19.34839151 1 0.4%
 
18.33812457 1 0.4%
 

vl_potenc_cons_oleo_gas
Numeric

Distinct count21
Unique (%)7.9%
Missing (%)91.7%
Missing (n)243
Infinite (%)0.0%
Infinite (n)0
Mean101.9090909
Minimum1
Maximum430
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2.05
Q121.25
Median45
Q3163.5
95-th percentile368.45
Maximum430
Range429
Interquartile range142.25

Descriptive statistics

Standard deviation125.4428001
Coef of variation1.230928458
Kurtosis1.339303396
Mean101.9090909
MAD100.5123967
Skewness1.485816228
Sum2242
Variance15735.8961
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%) 
32 2 0.8%
 
45 2 0.8%
 
22 1 0.4%
 
7 1 0.4%
 
216 1 0.4%
 
374 1 0.4%
 
226 1 0.4%
 
3 1 0.4%
 
138 1 0.4%
 
172 1 0.4%
 
Other values (10) 10 3.8%
 
(Missing) 243 91.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.4%
 
2 1 0.4%
 
3 1 0.4%
 
7 1 0.4%
 
8 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
430 1 0.4%
 
374 1 0.4%
 
263 1 0.4%
 
226 1 0.4%
 
216 1 0.4%
 

vl_total_tancagem
Categorical

Distinct count5
Unique (%)1.9%
Missing (%)96.2%
Missing (n)255
15
 
7
45
 
1
40
 
1
(Missing)
255
ValueCountFrequency (%) 
15 7 2.6%
 
45 1 0.4%
 
40 1 0.4%
 
30 1 0.4%
 
(Missing) 255 96.2%
 
Max length4
Mean length3.037735849
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

vl_total_tancagem_grupo
Highly correlated

This variable is highly correlated with vl_idade_minima_socios_pj and should be ignored for analysis

Correlation0.9444166274

vl_total_veiculos_antt
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_antt_grupo
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_leves
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.9328182339

vl_total_veiculos_leves_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_leves and should be ignored for analysis

Correlation0.9972729314

vl_total_veiculos_pesados
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.9929030146

vl_total_veiculos_pesados_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_pesados and should be ignored for analysis

Correlation0.9978083954

Correlations

Missing values

Sample

First rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadeUnnamed_0_xUnnamed_0_yvl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
0NaNNaNNaNNaNDE R$ 100.000.000,01 A R$ 300.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00NaNMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2005-11-03644.27NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseTrueNaNNaN117.0106.0522.0bb61c09449a1c1f8b78955d8b7a7f73599e78358993fe2...45.0NaNNaN44.0107.0162.0161.0113.069.044.0> 2021.813699NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN259.166667259.166667NaNNaNNaNNaNNaNNaN144.663535133.286943NaNNaN40.500000NaNNaNNaNNaN40.500000-2.466667NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALOESTE MARANHENSEPINDAREADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL26.063.3636.64845.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN100.00.0100.02745.0745.0745.0NaNNaN745.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOMAMANaN745.0NaN0.0000000.0000000.00000003116141308380.0144348380.0NaNNaN275282.0NaNNaNNaNNaNNaNNaNNaNNaN5.05.02.02.0
1NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE SIMPLES LIMITADAALTASERVICOS DE EDUCACAOACIMA DE 1 ANOVERDE2005-09-24688.31NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN19.09.091.016843c9ffb920170477118933798510d8d5f00f5c56c12...2.0NaN1.010.027.030.020.015.011.03.015 a 2016.389041NaN70.0NaNNaNNaN70.0NaN70.0NaNNaNNaNNaN149.033333149.033333NaNNaNNaNNaNNaNNaN65.94201742.166782NaNNaN4.866667NaNNaNNaNNaN4.8666670.000000NaNNaNENTIDADES EMPRESARIAISEDUCACAONORTE PIAUIENSEBAIXO PARNAIBA PIAUIENSEEDUCACAO23.047.9052.10291.021.0NaNNaNNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN172.07.0172.00119.0104.0113.0NaNNaN119.0NaNNaN2.0NaN1.0NaNNaN2.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOPIPINaN119.0NaN14.4230775.3097356.2500001368127818640.027818640.0NaNNaN60101.0NaNNaNNaNNaNNaNNaNNaNNaN1.01.01.01.0
2NaNNaNNaNNaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOAORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU D...ALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL1998-07-281881.35NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueFalseNaNNaN56.026.088.01b8d092daff12bed8b3c2ab93bf5df2921865a68aca185...73.0NaN1.07.010.011.012.09.014.033.0> 2040.380822NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN557.8666675014.966667NaNNaNNaNNaNNaNNaN284.854706216.077090NaNNaN24.200000NaNNaNNaNNaN24.2000000.633333NaNNaNADMINISTRACAO PUBLICAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALCENTRO AMAZONENSEMANAUSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.056.4743.53291.00.0NaNNaNNaNNaN32.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN121.00.0121.00170.0170.0177.0NaNNaN170.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOAMAMNaN170.0NaN0.000000-3.9548020.0000002478492728800.092728800.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
3NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOAMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL2005-10-14353.66NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrueNaNNaN35.053.063.03aafa3a1f12f483740a52956af100223333d0e3c79bf2c...14.0NaNNaNNaN8.018.029.022.031.029.0> 2043.854795NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN506.9666675014.966667NaNNaNNaNNaNNaNNaN189.020309316.503220NaNNaN31.333333NaNNaNNaNNaN31.3333338.733333NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALCENTRO NORTE PIAUIENSEVALENCA DO PIAUIADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.073.5126.49176.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN25.00.025.00151.0151.0151.0NaNNaN151.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOPIPINaN151.0NaN0.0000000.0000000.0000003742924418584.024418584.0NaNNaN87223.0NaNNaNNaNNaNNaNNaNNaNNaN1.01.02.02.0
4NaNNaNNaNNaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00NaNMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL2005-06-11NaNNaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseTrueNaNNaNNaN147.082.0c60431fbca90067f105570e1e8a684bcd7048205bbf6c4...24.0NaNNaN6.010.012.045.050.048.034.0> 2043.865753NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN556.8333335014.966667NaNNaNNaNNaNNaNNaN238.418341146.443381NaNNaN23.200000NaNNaNNaNNaN34.033333-0.066667NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALAGRESTE POTIGUARBAIXA VERDEADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.072.9327.07836.00.0NaNNaNNaNNaN4.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN607.00.0606.01229.0229.0418.0NaNNaN229.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaN229.0NaN0.000000-45.2153110.0000004800138585484.038585484.0NaNNaN23412.0NaNNaNNaNNaNNaNNaNNaNNaN0.00.00.00.0
5634.266667NaN145.700000NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOAASSOCIACAO PRIVADAALTASERVICOS DE EDUCACAOACIMA DE 1 ANOVERDE2005-09-241016.4810770780.030684070.0FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueTrueNaNNaN11.015.0144.05de08033561948a226f8ba8f8668a4ff4123be8ea7114d...13.0NaN2.09.029.028.026.035.018.010.0> 2047.087671634.26666740.0389.983333389.983333NaN38.0145.70000036.010560780.025483750.015.0309.0397.633333481.3000004224312.010468051.05385390.015342035.010.0159.099.53019678.1542364224312.05491605.520.433333210000.05200320.05.09.020.4333330.2000004224312.0515160.0ENTIDADES SEM FINS LUCRATIVOSEDUCACAOLESTE POTIGUARNATALEDUCACAO23.045.2954.71424.00.0NaNNaNNaNNaN1.02.02.00.00.00.00.00.00.02.00.00.00.00.00.00.00.00.00.02.00.00.02.00.00.00.02.00.00.00.0254.00.0254.01170.0170.0206.0112.0318.0393.02.01.03.02.0NaN2.0NaN3.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇORNRN10770780.0170.020.00.000000-17.4757280.0000005827242500700.093862150.04224312.010983211.0141655.0NaNNaNNaNNaNNaNNaNNaNNaN2.04.01.01.0
6NaNNaNNaNNaNDE R$ 100.000.000,01 A R$ 300.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00BOAORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU D...ALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2003-02-061811.66NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseFalseNaNNaN53.0297.0268.0194e619cb6417f92f75653406cf04106debc5035f13a88...216.0NaN5.015.043.042.029.051.078.0139.015 a 2015.734247NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN191.600000467.233333NaNNaNNaNNaNNaNNaN138.385891126.687314NaNNaN24.200000NaNNaNNaNNaN24.2000002.566667NaNNaNADMINISTRACAO PUBLICAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALNORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.049.3550.65896.00.0NaNNaNNaNNaN3.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN277.00.0278.00619.0619.0690.0NaNNaN618.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOMAMANaN618.0NaN0.000000-10.2898550.00000068626195554740.0195554740.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
7NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOAEMPRESARIO INDIVIDUALALTASERVICOS DE ALOJAMENTO/ALIMENTACAOACIMA DE 1 ANOVERDE2003-03-15857.89NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrueNaNNaN18.0143.07.0cc734f72fdd8753ba2e7638f3d09e0597fd859735904da...3.0NaN10.026.034.038.028.018.07.04.0> 2026.520548NaN63.0NaNNaNNaN63.0NaN63.0NaNNaNNaNNaN274.300000274.300000NaNNaNNaNNaNNaNNaN44.56627029.254984NaNNaN2.433333NaNNaNNaNNaN2.433333-0.600000NaNNaNOUTROSALIMENTACAOCENTRO AMAZONENSEMANAUSALOJAMENTO E ALIMENTACAO23.022.6277.38428.010.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN260.02.0260.01168.0160.0186.0NaNNaN168.0NaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOAMAMNaN168.0NaN5.000000-9.6774191.2195127898626994384.027924384.0NaNNaN382387.0NaNNaNNaNNaNNaNNaNNaNNaN3.03.05.05.0
861.333333NaN17.933333NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2010-05-20NaN19171824.019381824.0FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrue2.0NaN17.098.064.07e46107cb32e64f7f90ec16372d29f205f0d9781140308...6.05.010.036.040.043.019.011.07.04.05 a 108.44657561.33333341.032.54444432.544444NaN40.017.93333339.018751824.018961824.01.0118.083.73333383.7333337500729.57500729.56390608.06460608.01.0118.030.02985318.9084077500729.57500729.52.033333210000.0210000.01.0118.02.033333-0.6000007500729.57500729.5ENTIDADES EMPRESARIAISSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...VALE DO ACRERIO BRANCOATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS23.028.1871.82452.058.0NaNNaNNaNNaN6.03.03.00.00.00.00.00.00.03.00.03.00.00.00.00.00.00.00.03.00.00.00.03.00.00.00.00.00.00.0270.049.0270.00182.0179.0131.0118.0118.0181.01.01.02.05.0NaN2.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOACAC19171824.0181.03.01.67597838.93129827.60563481096835185428.035185428.07500729.57500729.5559626.0NaNNaNNaNNaNNaNNaNNaNNaN11.011.01.01.0
9116.133333NaN116.133333NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOVERDE2007-10-182346.0923182200.023182200.0FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN15.0117.016.02206453fbc92af65e47ce6ee2be27fa90ac427845ea0a5...1.0NaN23.041.021.026.016.011.07.02.010 a 1511.035616116.13333364.0116.133333116.133333NaN49.0116.13333334.023182200.023182200.0NaN161.0113.533333113.5333339272880.09272880.023182200.023182200.0NaN161.040.44977521.5827709272880.09272880.02.93333323182200.023182200.0NaN161.02.933333-0.5000009272880.09272880.0ENTIDADES EMPRESARIAISSERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGIST...NaNNaNATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...23.061.4938.51978.029.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.01.00.00.01.00.00.00.0830.050.0830.00148.0167.0220.0161.0161.0148.01.01.02.01.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇORORO23182200.0148.0NaN-11.377246-32.72727331.54574191274322357944.022357944.09272880.09272880.0248083.0NaNNaNNaNNaNNaNNaNNaNNaN3.03.00.00.0

Last rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadeUnnamed_0_xUnnamed_0_yvl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
255NaNNaNNaNNaNDE R$ 100.000.000,01 A R$ 300.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00NaNORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU D...ALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2005-11-033419.68NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueTrueNaNNaN63.0271.0229.01ec76d8ef1d7c6bb73ef86a43d713725b1b610240bdf4a...210.01.08.011.040.028.030.048.071.0116.015 a 2019.843836NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN490.433333490.433333NaNNaNNaNNaNNaNNaN180.18144297.031514NaNNaN3.466667NaNNaNNaNNaN3.4666671.800000NaNNaNADMINISTRACAO PUBLICAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALNORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL22.055.4244.581484.06.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN920.08.0920.00564.0566.0615.0NaNNaN563.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOMAMANaN563.0NaN-0.353357-8.2926831.415929255452076169642190.0169642190.0NaNNaN10151299.0NaNNaNNaNNaNNaNNaNNaNNaN101.0101.00.00.0
256516.933333NaN39.733333NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS DE SAUDEACIMA DE 1 ANOVERDE2005-11-032348.343.915216e+063.915216e+06FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueTrueNaNNaN12.091.042.0a3d4217a7c01f6cabd26d86cb283923c682a18d516f015...NaNNaN13.023.032.033.018.016.06.04.015 a 2019.761644516.93333344.0203.111111203.111111NaN41.539.73333339.02.843683e+062.843683e+06NaN13.0121.600000121.600000947894.4947894.41.305072e+061.305072e+06NaN7.00000052.99954340.7570374.533408e+054.533408e+053.933333329702.4329702.4NaN4.03.9333330.466667164851.2164851.2ENTIDADES EMPRESARIAISATIVIDADES DE ATENCAO A SAUDE HUMANACENTRO NORTE PIAUIENSETERESINASAUDE HUMANA E SERVICOS SOCIAIS23.069.6630.34270.014.0NaNNaNNaNNaNNaN3.03.00.00.00.00.00.00.03.00.00.00.02.00.00.00.00.00.03.00.00.03.00.00.00.01.00.00.00.0124.09.0124.03146.0141.0166.021.021.0145.03.01.02.04.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOPIPI3.915216e+06145.0NaN3.546099-12.0481936.27177725645213024727680.028697680.01.360022e+061.360022e+06182413.0NaNNaNNaNNaNNaNNaNNaNNaN4.04.02.02.0
25725.566667NaN25.566667NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOAEMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITAD...ALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2005-10-143021.532.100000e+052.100000e+05FalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrue1.0NaN73.0122.05.0feb9c97a3f694c22a919d9544c433da92d34d5717b43d5...2.0NaN19.028.046.035.027.019.016.09.015 a 2016.76986325.566667NaN25.56666725.566667NaNNaN25.566667NaN2.100000e+052.100000e+05NaNNaN92.23333392.233333NaNNaN2.100000e+052.100000e+05NaNNaN18.9296128.896976NaNNaN3.700000210000.0210000.0NaNNaN3.700000-0.533333NaNNaNOUTROSSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...NORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS23.04.9895.02983.0230.0NaNNaNNaNNaN5.01.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.01.00.01.00.00.01.00.00.00.00.00.00.00.0777.0186.0774.00206.0152.0119.0NaNNaN201.01.01.01.01.0NaNNaNNaN1.00.0NaNNaNNaNNaNNaNNaNNaN1.0SERVIÇOMAMA2.100000e+05201.0NaN35.52631673.109244101.08695725745267631321728.031321728.0NaNNaN85833.0NaNNaNNaNNaNNaNNaNNaNNaN4.04.00.00.0
258NaNNaNNaNNaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOAORGAO PUBLICO DO PODER EXECUTIVO MUNICIPALMEDIAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL2000-12-271359.01NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseFalseNaNNaN18.0305.055.0efd51c8f53a5931f1778398c485a861169c99a40072d8f...206.0NaN2.02.010.013.011.09.051.074.015 a 2017.846575NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN607.633333607.633333NaNNaNNaNNaNNaNNaN353.954938281.495431NaNNaN37.266667NaNNaNNaNNaN37.266667-0.266667NaNNaNADMINISTRACAO PUBLICAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALCENTRO NORTE PIAUIENSETERESINAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.014.0285.98572.00.0NaNNaNNaNNaN6.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN194.00.0194.00378.0378.0379.0NaNNaN378.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOPIPINaN378.0NaN0.000000-0.2638520.00000025845379359810076.059810076.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
259NaNNaNNaNNaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00NaNMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL2005-04-02372.23NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseTrueNaNNaN15.0305.033.0120ecac76e64ace3880969e7a6c7a20ff116b94a411fd0...23.0NaN2.05.035.044.092.060.061.031.0> 2043.539726NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN501.0666675014.966667NaNNaNNaNNaNNaNNaN181.59282392.680587NaNNaN2.500000NaNNaNNaNNaN2.500000-5.100000NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALLESTE POTIGUARLITORAL NORDESTEADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.052.1247.88977.09.0NaNNaNNaNNaN18.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN624.00.0624.01353.0344.0564.0NaNNaN353.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaN353.0NaN2.616279-37.4113480.00000025945434163313164.063313164.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.00.01.01.0
260206.900000NaN27.166667NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOACOOPERATIVAALTASERVICOS FINANCEIROSACIMA DE 1 ANOVERDE2005-11-031365.701.462024e+071.779363e+07FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaN16.072.0b6966d868fb7976f993aca02fb667c9ae8f5ebf4d2e033...5.02.06.024.018.021.02.06.02.02.015 a 2018.980822206.90000052.0126.222222126.222222NaN52.027.16666752.01.045775e+071.045775e+073.057.0176.300000218.2000004183099.24183099.24.873414e+065.931209e+063.042.33333351.35393343.7035092.088115e+062.617013e+062.266667700617.63461875.23.026.02.266667-0.300000350308.81730937.6ENTIDADES EMPRESARIAISATIVIDADES DE SERVICOS FINANCEIROSNaNNaNATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS R...23.055.6844.32152.012.0NaNNaNNaNNaNNaN3.03.00.00.00.00.00.00.03.00.00.00.00.00.00.00.00.00.03.00.00.00.01.00.00.03.02.00.00.063.09.063.0089.086.073.0106.0127.088.03.02.02.03.0NaN1.0NaN2.00.0NaNNaNNaNNaNNaN1.0NaN2.0SERVIÇORORO1.462024e+0788.03.03.48837221.91780810.28571426045484423903424.023903424.06.264346e+067.851038e+06NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
261158.600000NaN20.600000NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS DE SAUDEACIMA DE 1 ANOVERDE2002-11-162484.074.200000e+054.200000e+05FalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrue1.0NaN4.0119.073.04a87a82771996c18afc68a17d139bd318d08fa3e5dcf9f...NaN6.020.046.044.034.023.012.08.04.0> 2022.493151158.60000051.089.60000089.600000NaN36.020.60000027.02.100000e+052.100000e+05NaNNaN271.800000271.800000NaNNaN2.100000e+052.100000e+05NaNNaN63.10049349.762882NaNNaN2.533333210000.0210000.0NaNNaN2.5333330.600000NaNNaNENTIDADES EMPRESARIAISATIVIDADES DE ATENCAO A SAUDE HUMANACENTRO NORTE PIAUIENSETERESINASAUDE HUMANA E SERVICOS SOCIAIS25.068.0231.98414.027.0NaNNaNNaNNaN4.02.02.00.00.00.00.00.00.02.00.00.00.01.00.00.00.00.00.02.00.00.02.00.00.00.01.00.00.00.0211.030.0210.03203.0206.0243.0NaNNaN224.02.01.04.05.01.02.0NaN4.00.0NaNNaNNaNNaNNaN3.0NaN1.0SERVIÇOPIPI4.200000e+05197.0NaN-1.456311-16.46090514.66992726145745730136860.033145394.0NaNNaN447145.0NaNNaNNaNNaNNaNNaNNaNNaN7.07.00.00.0
26256.200000NaN56.200000NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2006-02-01NaN9.300000e+059.300000e+05FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueFalseNaNNaN150.0127.02.0f3b468c4066fac0d2de28bdafa87ec8b9d103a085cf7de...34.0NaN6.021.026.045.041.043.044.019.010 a 1512.74520556.20000049.056.20000056.200000NaN41.056.20000033.09.300000e+059.300000e+05NaNNaN5099.0666675099.066667NaNNaN9.300000e+059.300000e+05NaNNaN173.80967761.097177NaNNaN20.733333930000.0930000.0NaNNaN24.700000-0.566667NaNNaNENTIDADES EMPRESARIAISSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...CENTRO AMAZONENSEMANAUSATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS23.063.4436.56981.00.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.01.00.00.01.00.00.00.0702.08.0702.00279.0287.0296.0NaNNaN279.01.01.02.01.0NaN2.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOAMAM9.300000e+05279.0NaN-2.787456-5.7432432.82685526245791740955220.040955220.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
263321.633333NaN10.366667NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOACOOPERATIVAALTASEGUROS, PLANOS DE PREVIDENCIA E PLANOS DE SAUDEACIMA DE 1 ANOAZUL2003-11-082281.442.275368e+072.720860e+07FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN6.045.069.098448fefe3e358578fa643b63fcdcf4a3f2dcb496863f8...3.07.09.022.022.021.012.012.06.06.0> 2026.402740321.63333370.0166.300000166.300000NaN59.510.36666745.02.107004e+072.552496e+074.072.0286.333333286.3333338428018.010550477.03.792280e+064.534767e+063.536.50000067.99421555.2086294.244919e+065.306148e+062.933333123638.4123638.43.01.02.9333330.33333361819.261819.2ENTIDADES EMPRESARIAISSEGUROS RESSEGUROS PREVIDENCIA COMPLEMENTAR E ...VALE DO ACRERIO BRANCOATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS R...23.070.8329.17282.018.0NaNNaNNaNNaN1.06.06.00.00.00.00.00.00.06.00.00.00.01.00.00.00.00.01.06.00.00.00.05.00.00.05.01.00.00.0161.011.0160.05121.0114.0109.059.073.0319.04.02.04.06.01.03.0NaN4.00.0NaNNaNNaNNaNNaN4.0NaN3.0SERVIÇOACAC2.275368e+07120.07.06.14035111.0091749.36170226345928730033828.061489496.08.489837e+061.061230e+07156585.0NaNNaNNaNNaNNaNNaNNaNNaN2.02.01.01.0
264596.233333NaN16.700000NaNDE R$ 300.000.000,01 A R$ 500.000.000,00DE R$ 500.000.000,01 A 1 BILHAO DE REAISBOASOCIEDADE ANONIMA FECHADAALTAINDUSTRIA DIGITALACIMA DE 1 ANOVERDE2008-01-145985.495.223031e+095.451955e+09FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMTrueFalseFalseFalseTrueFalseNaNNaN140.02447.0563.0251f454db948590c50df496ea83f76e2227e24a32c2814...5.07.0643.0949.0749.0444.0200.095.041.017.010 a 1510.794521596.23333372.0106.631111106.631111NaN52.516.70000035.05.150974e+095.372531e+09275.01716.030.333333146.600000171568880.0241816100.03.482021e+083.634637e+0824.0361.60000023.34154118.2843453.669588e+075.131406e+073.433333210000.0210000.01.010.03.433333-0.466667288489.6288489.6ENTIDADES EMPRESARIAISATIVIDADES DE PRESTACAO DE SERVICOS DE INFORMACAONORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISINFORMACAO E COMUNICACAO23.033.5666.445340.0465.0NaNNaNNaNNaNNaN15.015.01.00.00.00.00.00.015.00.00.08.01.00.00.00.010.00.015.00.00.04.01.00.010.03.02.00.00.02168.0394.02162.063172.03186.03460.01229.01808.03787.07.04.05.028.0NaN4.0NaN5.00.0NaNNaNNaNNaNNaN4.0NaN5.0SERVIÇOMAMA5.223031e+093150.0288.0-0.439422-8.32369912.561773264460027459934850.0560530400.01.834794e+082.565703e+08NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0